Re: Finding Tables

From: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
To: Desmond Coughlan <desmond(at)coughlan(dot)net>
Cc: PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Finding Tables
Date: 2000-07-24 20:29:50
Message-ID: 397CA73E.A482D75D@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message D. Duccini 2000-07-24 20:32:19 Re: Finding Tables
Previous Message Tom Lane 2000-07-24 16:41:34 Re: Alter table with arrays