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/i.../app-psql.html http://www.postgresql.org/docs/8.0/i.../catalogs.html http://www.postgresql.org/docs/8.0/i...on-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/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to
majordomo@postgresql.org so that your
message can get through to the mailing list cleanly