Re: Find out when a table was last changed ?

Better yet, define a trigger so you and/or other programmers don't have
to worry about including that field in every update.

-Jonathan

----- Original Message -----
From: Anand Raman <araman(at)india-today(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, February 27, 2001 8:28 PM
Subject: Re: Find out when a table was last changed ?

> No u need to maintain this information in another column such as
> last_update_date which your application should update everyt time u
> perform any operation on it..
>
> Hope this helps
> Anand
>
> On Wed, Feb 28, 2001 at 04:24:52AM +0100, Markus Fischer wrote:
> >Hi,
> > Is there some kind of command or internal PostgreSql
> >column to find out when a table was last changed (INSERT, UPDATE
> >or DELETE) on a 7.0.2 Server ?
> >
> >thanks,
> > Markus
> >
> >--
> >Markus Fischer, http://josefine.ben.tuwien.ac.at/~mfischer/
> >EMail: mfischer(at)josefine(dot)ben(dot)tuwien(dot)ac(dot)at
> >PGP Public Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc
> >PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0
>