Re: table creation/modification datestamp

From: Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: table creation/modification datestamp
Date: 2008-05-26 21:25:56
Message-ID: 20080526232556.6ef551d9@iridium.wars-nicht.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2008-05-26 21:37:20 Re: table creation/modification datestamp
Previous Message Andrew Sullivan 2008-05-26 20:39:58 Re: table creation/modification datestamp