Re: List of postgreSQL databases

Поиск
Список
Период
Сортировка
От Andreas 'ads' Scherbaum
Тема Re: List of postgreSQL databases
Дата
Msg-id 20100510204001.308bd971@platin.wars-nicht.de
обсуждение исходный текст
Ответ на Re: List of postgreSQL databases  (Sergey Konoplev <gray.ru@gmail.com>)
Ответы Re: List of postgreSQL databases  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Greg Spiegelberg
Дата:
Сообщение: Re: postgres invoked oom-killer
Следующее
От: Tom Lane
Дата:
Сообщение: Re: List of postgreSQL databases