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 B653A11F6966 for ; Sun, 2 Apr 2006 13:46:50 -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 00970-01 for ; Sun, 2 Apr 2006 13:46:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 9166C11F66DD for ; Sun, 2 Apr 2006 13:46:48 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k32GkhJK023724; Sun, 2 Apr 2006 12:46:43 -0400 (EDT) To: "Rajesh Kumar Mallah" cc: andy.shellam@mailnetwork.co.uk, "Christopher Browne" , pgsql-admin@postgresql.org Subject: Re: Show tables query In-reply-to: References: <878xqo9m8q.fsf@wolfe.cbbrowne.com> <20060402145326.D69E411F6AFD@postgresql.org> Comments: In-reply-to "Rajesh Kumar Mallah" message dated "Sun, 02 Apr 2006 21:02:09 +0530" Date: Sun, 02 Apr 2006 12:46:43 -0400 Message-ID: <23723.1143996403@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.114 required=5 tests=[AWL=0.114] X-Spam-Score: 0.114 X-Spam-Level: X-Archive-Number: 200604/18 X-Sequence-Number: 21187 "Rajesh Kumar Mallah" writes: > 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. Unfortunately, the SQL committee did tremendous damage to that argument by changing the definitions of some of those views in SQL2003 :-( I'd still agree that the information_schema is less likely to change than the underlying catalogs, but it's not an ironclad guarantee that your app won't break. (We haven't caught up to the SQL2003 behavior yet, but I believe Peter Eisentraut is working on it for PG 8.2.) regards, tom lane