X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 957D911F6C70 for ; Sun, 2 Apr 2006 06:07:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36099-03 for ; Sun, 2 Apr 2006 06:07:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 6EB0911F6B01 for ; Sun, 2 Apr 2006 06:07:06 -0300 (ADT) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:1532 helo=acsdesk1) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FPyY5-0001Xi-4e for pgsql-admin@postgresql.org; Sun, 02 Apr 2006 10:07:05 +0100 Reply-To: From: "Andy Shellam" To: Subject: Show tables query Date: Sun, 2 Apr 2006 10:06:14 +0100 Organization: the mail network MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0004_01C6563D.13C1A750" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcZWNLCvnjlSK5dQTNSJdGl7OVfDvg== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-Id: <20060402090706.6EB0911F6B01@postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.939 required=5 tests=[AWL=0.011, HTML_MESSAGE=0.001, MSGID_FROM_MTA_ID=0.927] X-Spam-Score: 0.939 X-Spam-Level: X-Archive-Number: 200604/7 X-Sequence-Number: 21176 This is a multi-part message in MIME format. ------=_NextPart_000_0004_01C6563D.13C1A750 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0004_01C6563D.13C1A750 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Hi,
 
Is = there an SQL=20 command supported by Postgres to return a list of tables in a=20 database?
 
For = example on=20 mySQL, you can connect to a database and issue the command SHOW TABLES = to bring=20 back a list of tables in that database.
In PG = this throws=20 the error "unknown configuration parameter TABLES."
 
Any=20 ideas?
 
Thanks
 
Andy
------=_NextPart_000_0004_01C6563D.13C1A750--