Postgres Pro
Downloads
Home   >   mailing lists

Re: How Do I Find the Date When A Table Was Last Changed? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: How Do I Find the Date When A Table Was Last Changed?
Date
Msg-id dcc563d10810271643u15f00766u9fae1608e9a6a58c@mail.gmail.com
Whole thread Raw
In response to How Do I Find the Date When A Table Was Last Changed?  (Bill Thoen <bthoen@gisnet.com>)
List pgsql-general
Tree view 
On Mon, Oct 27, 2008 at 4:02 PM, Bill Thoen <bthoen@gisnet.com> wrote:
> Is there a way to find when data in a postgresql table was last changed?

what do you mean by changed?  Data updated?  schema changed?
PostgreSQL provides neither by default really.  You could set up an
update trigger to handle the issue of data being changed.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.3.3 chooses wrong query plan when LIMIT 1 added?
Next
From: Bruno Baguette
Date:
Subject: Re: [PLPGSQL] PERFORM into an EXECUTE allowed ?