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

Re: table creation/modification datestamp

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: table creation/modification datestamp
Date: 2008-05-26 20:39:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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.

Andrew Sullivan
+1 503 667 4564 x104

In response to


pgsql-admin by date

Next:From: Andreas 'ads' ScherbaumDate: 2008-05-26 21:25:56
Subject: Re: table creation/modification datestamp
Previous:From: Kevin NeufeldDate: 2008-05-26 18:18:37
Subject: table creation/modification datestamp

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