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"
