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@xxxxxxxxxxx> > 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
