Re: Name -> number ...

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 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 is where do
> database names go. My guess is pg_database.oid.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org