Name -> number ...

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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

The Hermit Hacker <scrappy@hub.org> 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 pg_database;

I think Bruce did a contrib utility to keep track of this, too.

regards, tom lane

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@candle.pha.pa.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@hub.org secondary: scrappy@{freebsd|postgresql}.org

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

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026