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