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

From Bruno Wolff III
Subject Re: SQL Command - To List Tables ?
Date
Msg-id 20030828031731.GA7185@wolff.to
Whole thread Raw
In response to Re: SQL Command - To List Tables ?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
On Wed, Aug 27, 2003 at 08:09:16 -0500,
  Bruno Wolff III <bruno@wolff.to> wrote:
> On Wed, Aug 27, 2003 at 20:37:14 +1000,
>   Peter Moscatt <pgmoscatt@optushome.com.au> wrote:
> > Is there a SQL command I can issue which will list all the TABLES within
> > a database ?
>
> select datname from pg_database;

This was an oops. I misread your question as asking for all databases,
not tables.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem with upgrading 7.2 -> 7.3.4
Next
From: Alex
Date:
Subject: Re: plpgsql FOUND Variable