On Fri, Sep 22, 2006 at 11:30:55AM -0500, Scott Marlowe wrote: > On Fri, 2006-09-22 at 11:17, Jim C. Nasby wrote: > > On Fri, Sep 22, 2006 at 10:30:55AM -0400, Tom Lane wrote: > > > Jim Nasby <jim@xxxxxxxxx> writes: > > > > On Sep 20, 2006, at 11:45 AM, Jessica Richard wrote: > > > >> I would like to know when each of my databases were created. > > > > > > > You're not the first person to ask for this, but it's still pretty > > > > unclear what the use-case for that info is (and without a decent use- > > > > case, it's pretty unlikely that this info will get stored). > > > > > > If we did store it, it would presumably reflect the time of issuance of > > > CREATE DATABASE, which would mean it wouldn't survive a dump and reload > > > anyway (as the OP seems to be wishing for). > > > > Well, that case could be handled as well, it's just a SMOC. But as I > > mentioned, it's unlikely an existing developer will get excited about > > any of this. > > How about a default database comment on creation if the user doesn't set > one, of "database created 2006-09-21 12:34:56" If we had catalog triggers, one could do that automagically... -- Jim Nasby jim@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
