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 A57DD11F796F for ; Sun, 2 Apr 2006 12:32:13 -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 88551-05 for ; Sun, 2 Apr 2006 12:32:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.187]) by postgresql.org (Postfix) with ESMTP id D6DDF11F6AF5 for ; Sun, 2 Apr 2006 12:32:10 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id l24so792318nfc for ; Sun, 02 Apr 2006 08:32:10 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=FtaFMaz966HjSXUU91I005AYGWgKz+LQERTgeWwiAXHNWvLyo5H1B3BdDCS8PbXA4tXGebv8yMKazvWfC+AWI67MbPc/ifzLGmHtkhDPz0xiY/7NcyAkpAnWL4E1bDHhGZZ9uoPi/RvCspVFdaG6dvuldrbwWuBRvi3FYVVf/FY= Received: by 10.49.80.4 with SMTP id h4mr1649743nfl; Sun, 02 Apr 2006 08:32:09 -0700 (PDT) Received: by 10.49.26.20 with HTTP; Sun, 2 Apr 2006 08:32:09 -0700 (PDT) Message-ID: Date: Sun, 2 Apr 2006 21:02:09 +0530 From: "Rajesh Kumar Mallah" To: andy.shellam@mailnetwork.co.uk Subject: Re: Show tables query Cc: "Christopher Browne" , pgsql-admin@postgresql.org In-Reply-To: <20060402145326.D69E411F6AFD@postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <878xqo9m8q.fsf@wolfe.cbbrowne.com> <20060402145326.D69E411F6AFD@postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.148 required=5 tests=[AWL=-0.184, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.148 X-Spam-Level: * X-Archive-Number: 200604/15 X-Sequence-Number: 21184 On 4/2/06, Andy Shellam wrote: > > After takin a swig o' Arrakan spice grog, andy.shellam@mailnetwork.co.u= k > ("Andy Shellam") belched out: > >> Is there an SQL command supported by Postgres to return a list of tabl= es > 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 exclusivel= y > 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 els= e > 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 dramaticall= y ? (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 >