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: 20080526203958.GT21327@commandprompt.com (view raw or flat)
Thread:
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.

A
-- 
Andrew Sullivan
ajs(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

Responses

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-2014 The PostgreSQL Global Development Group