77 databases in data/base directory ... all number'd ...
select * from pg_database;
doesn't give me the reference to which directory is which database ... so
what table do we need to join on to get this information?
thanks ...
Marc G. Fournier ICQ#7615664 IRC
d'oh, should have extended my query ...
select oid,* from pg_database;
gives the directory name ...
Interesting to not that reffilenode is for tables, but oid is for
databases. I hadn't realized that distinction until you asked. You
can't rename databases, so the oid is OK for
77 databases in data/base directory ... all number'd ...
select * from pg_database;
doesn't give me the reference to which directory is which database ... so
what table do we need to join on to get this information?
thanks ...
Info is in pg_class.relfilenode. Now the big question
d'oh, should have extended my query ...
select oid,* from pg_database;
gives the directory name ...
thanks :)
On Sat, 14 Apr 2001, Bruce Momjian wrote:
77 databases in data/base directory ... all number'd ...
select * from pg_database;
doesn't give me the reference to which
The Hermit Hacker [EMAIL PROTECTED] writes:
77 databases in data/base directory ... all number'd ...
select * from pg_database;
doesn't give me the reference to which directory is which database ... so
what table do we need to join on to get this information?
select oid, datname from