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(at)cat-it(dot)co(dot)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(at)backpack(dot)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!"
-----------------------------------------------------------------------------