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:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
