Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group