Re: Finding Tables

start with \l  to get a list of the databases, then \c to connect to
whichever looks most promising and then execute the \dt

On Tue, 25 Jul 2000, Andrew McMillan wrote:

> 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
> 


-----------------------------------------------------------------------------
david@backpack.com            BackPack Software, Inc.        www.backpack.com
+1 651.645.7550 voice       "Life is an Adventure.    
+1 651.645.9798 fax            Don't forget your BackPack!"   
-----------------------------------------------------------------------------