Re: List of postgreSQL databases

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(dot)oliveira(at)grant(dot)co(dot)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