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 CBA4411F6AE4 for ; Sun, 2 Apr 2006 11:53:28 -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 82415-09 for ; Sun, 2 Apr 2006 11:53:29 -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 D69E411F6AFD for ; Sun, 2 Apr 2006 11:53:26 -0300 (ADT) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:1812 helo=acsdesk1) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FQ3xG-0001nk-VA; Sun, 02 Apr 2006 15:53:27 +0100 Reply-To: From: "Andy Shellam" To: "'Christopher Browne'" Cc: Subject: Re: Show tables query Date: Sun, 2 Apr 2006 15:53:11 +0100 Organization: the mail network MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <878xqo9m8q.fsf@wolfe.cbbrowne.com> Thread-Index: AcZWV+DICpPDesZHTk2HDXCmRIjxqAADK4kg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-Id: <20060402145326.D69E411F6AFD@postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.961 required=5 tests=[AWL=0.033, MSGID_FROM_MTA_ID=0.927] X-Spam-Score: 0.961 X-Spam-Level: X-Archive-Number: 200604/14 X-Sequence-Number: 21183 > After takin a swig o' Arrakan spice grog, andy.shellam@mailnetwork.co.uk ("Andy Shellam") belched out: >> Is there an SQL command supported by Postgres to return a list of tables in a database? Sorry, did I say something wrong? I thought it was a perfectly valid question actually. The application in mind is going to be run exclusively on Postgres, so I'm not overly fussed over standards - I just wanted a quick win, of which Grega's SQL gave it me perfectly - tables only, nothing else included.