Re: finding out about databases and tables

At 2:10 PM -0600 4/3/02, Ken Gerdes wrote:
>Hi,
>
>I am relatively new to Postgresql. I have Postgresql running on a
>Linux server, and I need to find out the names of all databases, and
>all tables within those databases, so I can start querying for data,
>and spool those results to a file for export. Can someone please
>tell me what commands I should run as a root user to find out this
>information, and query the databases for spooling to a file?
>
>Thanks,
>
>Ken
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html

if you have not deleted the test db

psql test
will get you a prompt
\? will get help on the \ commands
\h will get a list of help topics
\h topic will get a syntax for that command.

L>

--
searchmaster(at)apple(dot)com
lev(at)apple(dot)com