Postgres Pro
Downloads
Home   >   mailing lists

Show tables query - Mailing list pgsql-admin

From Andy Shellam
Subject Show tables query
Date
Msg-id 20060402090706.6EB0911F6B01@postgresql.org
Whole thread Raw
Responses Re: Show tables query
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: FW: Setting up of PITR system.
Next
From: Grega Bremec
Date:
Subject: Re: Show tables query