Re: Finding Tables

From: "D(dot) Duccini" <duccini(at)backpack(dot)com>
To: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
Cc: Desmond Coughlan <desmond(at)coughlan(dot)net>, PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Finding Tables
Date: 2000-07-24 20:32:19
Message-ID: Pine.GSO.4.03.10007241531500.2284-100000@ra.bpsi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Desmond Coughlan 2000-07-24 22:06:13 Finding Tables
Previous Message Andrew McMillan 2000-07-24 20:29:50 Re: Finding Tables