"Ian Lipsky" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]