Re: Find out when a table was last changed ? - Mailing list pgsql-general

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