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
