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@nasby.net]
Sent: Friday, January 12, 2007 11:01 PM
To: Negandhi, Nishith
Cc: pgsql-admin@postgresql.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@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)