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
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
>
> 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 qu
>
> 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 fo
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 N
