Postgres Pro
Downloads
Home   >   mailing lists

finding out about databases and tables - Mailing list pgsql-novice

From Ken Gerdes
Subject finding out about databases and tables
Date
Msg-id scab0d65.080@mail.lottery.state.tx.us
Whole thread Raw
Responses Re: finding out about databases and tables  (Lloyd Vancil <lev@apple.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: now() and interval
Next
From: Lloyd Vancil
Date:
Subject: novice question about NOTICE:...