Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id EDEFE632D41 for ; Mon, 10 May 2010 15:40:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 42033-07 for ; Mon, 10 May 2010 18:40:06 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from roadrunner.wars-nicht.de (roadrunner.wars-nicht.de [88.198.26.233]) by mail.postgresql.org (Postfix) with ESMTP id 73C2B632D40 for ; Mon, 10 May 2010 15:40:06 -0300 (ADT) Received: from platin.wars-nicht.de (f053201184.adsl.alicedsl.de [78.53.201.184]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by roadrunner.wars-nicht.de (Postfix) with ESMTP id E7F7B9D8006 for ; Mon, 10 May 2010 20:40:03 +0200 (CEST) Received: from platin.wars-nicht.de (unknown [127.0.0.1]) by platin.wars-nicht.de (Postfix) with ESMTP id EA2D0B92BA1 for ; Mon, 10 May 2010 20:40:02 +0200 (CEST) Date: Mon, 10 May 2010 20:40:01 +0200 From: Andreas 'ads' Scherbaum To: pgsql-admin@postgresql.org Subject: Re: List of postgreSQL databases Message-ID: <20100510204001.308bd971@platin.wars-nicht.de> In-Reply-To: References: <7965A9DCF12CC14984420BCC37B1608F25ABF30DE5@Elzar.grant.co.uk> X-Mailer: Claws Mail 3.7.2 (GTK+ 2.18.3; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/114 X-Sequence-Number: 34587 Hello, I want to raise this topic again. On Tue, 6 Apr 2010 15:39:35 +0400 Sergey Konoplev wrote: > On 6 April 2010 15:22, Renato Oliveira > wrote: > > Is there a specific =E2=80=98STATEMENT=E2=80=99 to display the same thi= ng? >=20 > Try this >=20 > SELECT datname FROM pg_database; Is this guaranteed to stay forever? Right now I'm developing a tool which needs to fetch the lost of available databases. Everytime I implement a query using pg_* (even such a simple one) I have a bad feeling about possible future compatibility issues. Isn't there a way to make the list of databases available in information_schema and change this view whenever the underlaying structure might change? Bye --=20 Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project