Thread: 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/