Re: How Do I Find the Date When A Table Was Last Changed?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Bill Thoen" <bthoen(at)gisnet(dot)com>
Cc: "pgsql-general General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How Do I Find the Date When A Table Was Last Changed?
Date: 2008-10-27 23:43:13
Message-ID: dcc563d10810271643u15f00766u9fae1608e9a6a58c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 27, 2008 at 4:02 PM, Bill Thoen <bthoen(at)gisnet(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Baguette 2008-10-27 23:49:13 Re: [PLPGSQL] PERFORM into an EXECUTE allowed ?
Previous Message Tom Lane 2008-10-27 22:57:43 Re: PostgreSQL 8.3.3 chooses wrong query plan when LIMIT 1 added?