Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno Wolff III
Subject Re: SQL Command - To List Tables ?
Date
Msg-id 20030827130916.GH25066@wolff.to
Whole thread Raw
In response to SQL Command - To List Tables ?  (Peter Moscatt <pgmoscatt@optushome.com.au>)
Responses Re: SQL Command - To List Tables ?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
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;

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Postgresql for Solaris on Sparc
Next
From: Bruno Wolff III
Date:
Subject: Re: pgplsql - Oracle nvl