listing all tables
I finally got my windows install of postgresql to work (as a service). It
would not work when I did the other install (not as a windows service).
Now, I am working through some tutorial examples.
My question is, what command can I issue to list all the tables in a
database?
I found the command ANALYZE VERBOSE ... but is there something else,
analogous to the DIR command in DOS, to show all the tables (files)?
Thanks
On Thu, Apr 21, 2005 at 11:33:07PM -0400, Typing80wpm@aol.com wrote:
My question is, what command can I issue to list all the tables in a
database?
If you're using psql then you can use the \dt command, although that
will show only the tables in your search path (which is probably what
you're interested in). See "Meta-Commands" in the psql documentation
for more info; see also the "System Catalogs" and "The Information
Schema" chapters.
http://www.postgresql.org/docs/8.0/interactive/app-psql.html
http://www.postgresql.org/docs/8.0/interactive/catalogs.html
http://www.postgresql.org/docs/8.0/interactive/information-schema.html
One way to learn more about the system catalogs is to run "psql -E"
or execute "\set ECHO_HIDDEN" from within psql so you can see the
queries psql sends for commands like \dt, \d tablename, etc.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/