Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Desmond CoughlanDate: 2000-07-24 22:06:13
Subject: Finding Tables
Previous:From: Andrew McMillanDate: 2000-07-24 20:29:50
Subject: Re: Finding Tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group