Re: Finding Tables

Desmond Coughlan wrote:
>
> Hi,
> Be scared ... be very scared ... for I am DBA on a Linux-based
> implementation of PGSQL.  With > 4000 users ...
>
> The guy who installed the database, left a while back, and I've had the
> SQL training, but have never had to touch the database.  Until now.
>
> I connected as cyberdba, and tried to find out what tables are in the
> database, but I don't remember the command to let me know exactly what is
> there.

\d

There's really good documentation on the PostgreSQL website at:
http://www.postgresql.org/docs/index.html

You can download it too.

Regards,
                Andrew.
--
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267