Re: Last insert/update/delete time for a table

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Last insert/update/delete time for a table
Date: 2008-04-25 13:01:48
Message-ID: 20080425130148.GB19447@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 25, 2008 at 02:14:17PM +0200, Aleksander Kmetec - INTERA wrote:
> Is there a way to get the time of the last insert, update or delete
> statement for a specific table?

Only if you put a trigger on each table to collect that information.

A

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-04-25 13:26:26 Re: Last insert/update/delete time for a table
Previous Message Roberts, Jon 2008-04-25 12:47:06 pg_version is missing