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@india-today.com>
To: <pgsql-general@postgresql.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@josefine.ben.tuwien.ac.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
>