Re: [ADMIN] determining when a database was created

2004-06-04 Thread Gaetano Mendola
Somasekhar Bangalore wrote: Hi All, Is there a tool , where in i can convert data from postgres 7.3.2 to oracle 9i. http://www.oracle.com/support/index.html?contact.html thanks in advance som U'r welcome. Regards Gaeatano Mendola ---(end of broadcast)-

Re: [ADMIN] determining when a database was created

2004-05-31 Thread Tom Lane
"Somasekhar Bangalore" <[EMAIL PROTECTED]> writes: > Is there a tool , where in i can convert data from postgres 7.3.2 to oracle 9i. No doubt Oracle Corp. would be pleased to assist you with this question. I'm not sure why you expect a bunch of Postgres people to know the answer, though.

Re: [ADMIN] determining when a database was created

2004-05-31 Thread Somasekhar Bangalore
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:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 7:17 AM To: Ian Lipsky Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] determining when a

Re: [ADMIN] determining when a database was created

2004-05-31 Thread Tom Lane
"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

Re: [ADMIN] determining when a database was created

2004-05-31 Thread Ian Lipsky
[EMAIL PROTECTED] Sent: Mon, 31 May 2004 00:37:40 -0400 Subject: Re: [ADMIN] determining when a database was created Ian Lipsky <[EMAIL PROTECTED]> writes: > is there a way to tell when a database was created? Nope, PG doesn't record that anywhere. You could get an upper bound by looking

Re: [ADMIN] determining when a database was created

2004-05-30 Thread Tom Lane
Ian Lipsky <[EMAIL PROTECTED]> writes: > is there a way to tell when a database was created? Nope, PG doesn't record that anywhere. You could get an upper bound by looking for the oldest file mod time in the database's files. This isn't completely reliable, but unless you're in the habit of chan

[ADMIN] determining when a database was created

2004-05-30 Thread Ian Lipsky
is there a way to tell when a database was created? I've tried looking in some of the postgres system tables but i didnt see any that looked like it had a creation date. I would have also looked at the date the data folder for the database was created, but i didnt know which folder belonged to