Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 418AA9FA43C for ; Tue, 9 Jan 2007 11:36:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 60734-09 for ; Tue, 9 Jan 2007 11:35:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by postgresql.org (Postfix) with ESMTP id 14B839FA432 for ; Tue, 9 Jan 2007 11:36:00 -0400 (AST) Received: from [213.146.143.243] (port=33549 helo=[172.16.208.165]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.63) (envelope-from ) id 1H4J14-0002Lf-Nk; Tue, 09 Jan 2007 15:35:58 +0000 Message-ID: <45A3B67F.30209@mailnetwork.co.uk> Date: Tue, 09 Jan 2007 15:36:31 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: "Negandhi, Nishith" CC: pgsql-admin@postgresql.org Subject: Re: Database Create Date References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/72 X-Sequence-Number: 24228 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 "/base/"