Postgres Pro
Downloads
Home   >   mailing lists

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

From Shridhar Daithankar
Subject Re: SQL Command - To List Tables ?
Date
Msg-id 3F4CDA48.22895.3FFB74A@localhost
Whole thread Raw
In response to SQL Command - To List Tables ?  (Peter Moscatt <pgmoscatt@optushome.com.au>)
List pgsql-general
Tree view 
On 27 Aug 2003 at 20:37, Peter Moscatt wrote:

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

\dt from psql

or select relname from pg_class;

Check the column name.  There might be a typo there but pg_class is what you
are looking at.

Bye
 Shridhar

--
There are certain things men must do to remain men.        -- Kirk, "The Ultimate
Computer", stardate 4929.4

pgsql-general by date:

Previous
From: "mathan"
Date:
Subject: Re: SQL Command - To List Tables ?
Next
From: "Juris Krumins"
Date:
Subject: Again about temporary table