Show tables query

From: "Andy Shellam" <andy(dot)shellam(at)mailnetwork(dot)co(dot)uk>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Show tables query
Date: 2006-04-02 09:06:14
Message-ID: 20060402090706.6EB0911F6B01@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Is there an SQL command supported by Postgres to return a list of tables in
a database?

For example on mySQL, you can connect to a database and issue the command
SHOW TABLES to bring back a list of tables in that database.
In PG this throws the error "unknown configuration parameter TABLES."

Any ideas?

Thanks

Andy

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Grega Bremec 2006-04-02 09:34:27 Re: Show tables query
Previous Message Rajesh Kumar Mallah 2006-04-01 10:58:42 Re: FW: Setting up of PITR system.