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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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