Re: determining when a database was created

Hi All,

Is there a tool , where in i can convert data from postgres 7.3.2 to oracle 9i.

thanks in advance
som

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, June 01, 2004 7:17 AM
To: Ian Lipsky
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] determining when a database was created

"Ian Lipsky" <postgres(at)merk(dot)caltech(dot)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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org