From: Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
To: pgsql-admin@postgresql.org
Subject: Re: List of postgreSQL databases
Date: Mon, 10 May 2010 20:40:01 +0200
Message-ID: <20100510204001.308bd971@platin.wars-nicht.de> (raw)
In-Reply-To: <x2yc3a7de1f1004060439j35ad8c7m7db3abc046b1efd3@mail.gmail.com>
References: <7965A9DCF12CC14984420BCC37B1608F25ABF30DE5@Elzar.grant.co.uk>
<x2yc3a7de1f1004060439j35ad8c7m7db3abc046b1efd3@mail.gmail.com>
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 <renato.oliveira@grant.co.uk>
> wrote:
> > Is there a specific ‘STATEMENT’ to display the same thing?
>
> Try this
>
> 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
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: adsmail@wars-nicht.de
Subject: Re: List of postgreSQL databases
In-Reply-To: <20100510204001.308bd971@platin.wars-nicht.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox