Well..thats one way, however I only hv access to the web interface (i.e. phpAdmin).
-----Original Message----- From: Andy Shellam (Mailing Lists) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 9:37 AM To: Negandhi, Nishith Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Database Create Date Negandhi, Nishith wrote: > Hi, > I need to know the create date of databases on PosegreSQL. > PG_DATABASE does not provide this information. > Are there any other system catalogs that can provide the above > information?? > > Thanks > !DSPAM:37,45a3b385137101969839670! I'm sure there is (not known to me atm), but for a quick shot you could find the DB's "OID" from pg_database and look at the create date of "<pg data dir>/base/<db oid>" ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
