Postgres Pro
Downloads
Home   >   mailing lists

Thread: Knowing when a row was last updated

Knowing when a row was last updated

From
Antony Paul
Date:
Hi all,
  Is it possible to know when a row was last updated. Using 7.3.3.

rgds
Antony Paul

Re: Knowing when a row was last updated

From
Michael Fuhr
Date:
On Wed, Nov 17, 2004 at 07:43:31PM +0530, Antony Paul wrote:

>   Is it possible to know when a row was last updated. Using 7.3.3.

Add a TIMESTAMP or TIMESTAMP WITH TIME ZONE column to the table and
use a trigger to update it.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/