Re: SQL Command - To List Tables ?

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