Re: table creation/modification datestamp - Mailing list pgsql-admin

On Mon, 26 May 2008 16:39:58 -0400 Andrew Sullivan wrote:

> 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.

Maybe you mean:

http://pgfoundry.org/projects/tablelog/

But that covers only data changes. There's no way to track DDL changes.


Kind regards

--
                Andreas 'ads' Scherbaum
German PostgreSQL User Group