Thread: Finding Tables
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. Thanks in advance. D. -- Desmond Coughlan |Restez Zen ... UNIX peut le faire desmond@coughlan.net http://www.coughlan.net/desmond
On Mon, 24 Jul 2000, Mark, Terry wrote: > try \dt Hmm ... I type that command, and it says, 'Can't find any tables'. :-( D. -- Desmond Coughlan |Restez Zen ... UNIX peut le faire desmond@coughlan.net http://www.coughlan.net/desmond
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
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!" -----------------------------------------------------------------------------
On Mon, 24 Jul 2000, D. Duccini wrote: > start with \l to get a list of the databases, then \c to connect to > whichever looks most promising and then execute the \dt Bingo ... got it. Many thanks. I'm off to expirement now !! :-)) D. -- Desmond Coughlan |Restez Zen ... UNIX peut le faire desmond@coughlan.net http://www.coughlan.net/desmond