Re: Database Create Date

Hi Jim,
Thanks for your reply.
Well..there is no particular reason for knowing the database create
date, but I feel this information is something which should be known,
especially in a development environment where multiple database are
created and deleted. This helps in keep historical information.

Regards

-----Original Message-----
From: Jim C. Nasby [mailto:jim(at)nasby(dot)net]
Sent: Friday, January 12, 2007 11:01 PM
To: Negandhi, Nishith
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Database Create Date

On Tue, Jan 09, 2007 at 09:22:49AM -0600, 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??

This is the second time I remember someone asking for this, so maybe
it's worth adding... why is it you need to know when the database was
created?
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)