Re: how to check the creation date of a postgres database?
От | Jim C. Nasby |
---|---|
Тема | Re: how to check the creation date of a postgres database? |
Дата | |
Msg-id | 20060922161759.GE28987@nasby.net обсуждение исходный текст |
Ответ на | Re: how to check the creation date of a postgres database? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: how to check the creation date of a postgres database?
|
Список | pgsql-admin |
On Fri, Sep 22, 2006 at 10:30:55AM -0400, Tom Lane wrote: > Jim Nasby <jim@nasby.net> 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. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
В списке pgsql-admin по дате отправления: