Re: keeping track of when a row was last modified - Mailing list pgsql-general

From Michael Fuhr
Subject Re: keeping track of when a row was last modified
Date
Msg-id 20050310213723.GA7015@winnie.fuhr.org
Whole thread Raw
In response to keeping track of when a row was last modified  ("Sally Sally" <dedeb17@hotmail.com>)
List pgsql-general
On Thu, Mar 10, 2005 at 09:15:28PM +0000, Sally Sally wrote:

> Does postgres automatically keep track of when a row was last modified?

No, but you can set up a trigger to do it.  The "Trigger Procedures"
section of the PL/pgSQL chapter in the documentation has an example:

http://www.postgresql.org/docs/8.0/interactive/plpgsql-trigger.html

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

pgsql-general by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: keeping track of when a row was last modified
Next
From: "Jim C. Nasby"
Date:
Subject: Re: PostgreSQL still for Linux only?