Thread: finding out about databases and tables

Hi,

I am relatively new to Postgresql.  I have Postgresql running on a Linux server, and I need to find out the names of
alldatabases, and all tables within those databases, so I can start querying for data, and spool those results to a
filefor export.  Can someone please tell me what commands I should run as a root user to find out this information, and
querythe databases for spooling to a file? 

Thanks,

Ken

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@apple.com
                 lev@apple.com