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
