Home > mailing lists

Re: SQL Command - To List Tables ? - Mailing list pgsql-general

From	sector119@mail.ru
Subject	Re: SQL Command - To List Tables ?
Date	August 28, 2003 02:14:59
Msg-id	20030827115142.GA2284@city.gov.te.ua Whole thread Raw
In response to	SQL Command - To List Tables ? (Peter Moscatt <pgmoscatt@optushome.com.au>)
List	pgsql-general

> Is there a SQL command I can issue which will list all the TABLES within
> a database ?

select datname from pg_database;

--
WBR, sector119

From: Martijn van Oosterhout
Date: 28 August 2003, 02:14:52
Subject: Re: Database recovery after fs crash

From: Martijn van Oosterhout
Date: 28 August 2003, 02:16:28
Subject: Re: Database recovery after fs crash