Re: table creation/modification datestamp

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: table creation/modification datestamp
Дата
Msg-id 20080526203958.GT21327@commandprompt.com
обсуждение исходный текст
Ответ на table creation/modification datestamp  (Kevin Neufeld <kneufeld@refractions.net>)
Ответы Re: table creation/modification datestamp  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
Список pgsql-admin
On Mon, May 26, 2008 at 11:18:37AM -0700, Kevin Neufeld wrote:
> As a DBA, it would be extremely useful to know when tables have been
> created or modified.  PostgreSQL doesn't keep track of this, does it?

Nope.  There's a project in pgfoundry, IIRC, to do it with triggers.
You could also use Slony (or any of its work-similar friends) to do
something similar.

A
--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

В списке pgsql-admin по дате отправления:

Предыдущее
От: Kevin Neufeld
Дата:
Сообщение: table creation/modification datestamp
Следующее
От: Andreas 'ads' Scherbaum
Дата:
Сообщение: Re: table creation/modification datestamp