Thread: how to recognise databses

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.

> 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.

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