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