Re: table creation/modification datestamp - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: table creation/modification datestamp
Date
Msg-id 20080526203958.GT21327@commandprompt.com
Whole thread Raw
In response to table creation/modification datestamp  (Kevin Neufeld <kneufeld@refractions.net>)
Responses Re: table creation/modification datestamp
List 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@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

pgsql-admin by date:

Previous
From: Kevin Neufeld
Date:
Subject: table creation/modification datestamp
Next
From: Andreas 'ads' Scherbaum
Date:
Subject: Re: table creation/modification datestamp