Re: SQL Command - To List Tables ?

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: "PostgreSQL [GENERAL] " List <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL Command - To List Tables ?
Date: 2003-08-27 10:50:24
Message-ID: 3F4CDA48.22895.3FFB74A@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mathan 2003-08-27 11:07:11 Re: SQL Command - To List Tables ?
Previous Message Peter Moscatt 2003-08-27 10:37:14 SQL Command - To List Tables ?