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 BB28F11F6258 for ; Sun, 2 Apr 2006 12:41:00 -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 91060-03 for ; Sun, 2 Apr 2006 12:40:58 -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 453A411F602F for ; Sun, 2 Apr 2006 12:40:57 -0300 (ADT) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:1864 helo=acsdesk1) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FQ4hE-0001qj-R2; Sun, 02 Apr 2006 16:40:57 +0100 Reply-To: From: "Andy Shellam" To: "'Rajesh Kumar Mallah'" Cc: Subject: Re: Show tables query Date: Sun, 2 Apr 2006 16:40:40 +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: Thread-Index: AcZWar1a89wlcR8iSKixAHR9v6IELQAAH94g X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-Id: <20060402154057.453A411F602F@postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.968 required=5 tests=[AWL=0.041, MSGID_FROM_MTA_ID=0.927] X-Spam-Score: 0.968 X-Spam-Level: X-Archive-Number: 200604/16 X-Sequence-Number: 21185 Thanks Rajesh, That's always a risk anyway with anything - hence where upgrade testing comes in ;-) I'll probably go this way if I do indeed have this need still - it was only a preliminary thought process, I just thought I'd ask the question. Thanks Andy -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rajesh Kumar Mallah Sent: Sunday, 02 April, 2006 4:32 pm To: andy.shellam@mailnetwork.co.uk Cc: Christopher Browne; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Show tables query On 4/2/06, Andy Shellam wrote: > > 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. the information_schema approach is still better than querying the system catalogs. The system catalogs are internal to postgresql what if future versions of postgresql change the sys catalogs dramatically ? (your app breaks!) information_schema is the standard which are more likely to behave the same in all versions of pgsql becoz they are(currently) views on the sys catalogs. Regds Rajesh Kumar Mallah. > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend !DSPAM:14,442feeb335041315618668!