Re: determining when a database was created - Mailing list pgsql-admin

"Ian Lipsky" <postgres@merk.caltech.edu> writes:
> How can i determine which directory contains the database files? there
> are a few databases.

The database directory names correspond to the OID column of
pg_database.  So:

    SELECT datname, oid from pg_database;

(BTW, this is likely to change in 7.5 if tablespaces get done.)

See also the contrib/oid2name tool.

            regards, tom lane