Postgres Pro
Downloads
Home   >   mailing lists

Re: Knowing when a row was last updated - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Knowing when a row was last updated
Date
Msg-id 20041117143337.GA77078@winnie.fuhr.org
Whole thread Raw
In response to Knowing when a row was last updated  (Antony Paul <antonypaul24@gmail.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Antony Paul
Date:
Subject: Knowing when a row was last updated
Next
From: Oleg Bartunov
Date:
Subject: Re: TSearch2: Problems with compound words and stop words