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
> 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.
---(end of broadcast)---
TIP 6
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/fa
