how to recognise databses

Поиск
Список
Период
Сортировка
Искать

how to recognise databses

От:
Ashok Chauhan <ashok@kalculate.com>
Дата:

we have made 4 databases in postgresql, now we want to know how can be
recognize these database files in /var/lib/pgsql/data/base.

Re: how to recognise databses

От:
Mailing List <list@1006.org>
Дата:

> we have made 4 databases in postgresql, now we want to know how can be
> recognize these database files in /var/lib/pgsql/data/base.

Execute this query:

  select datname, datid from pg_stat_database;

Bye, Chris.


Re: how to recognise databses

От:
Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
Дата:
Вложения:
One good and very usefull script for that is oid2name .
You can find it in contrib/oid2name

Thierry Missimilly
 

Ashok Chauhan wrote:

we have made 4 databases in postgresql, now we want to know how can be
recognize these database files in /var/lib/pgsql/data/base.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

FAQ