Re: Find out when a table was last changed ?

From: Anand Raman <araman(at)india-today(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Find out when a table was last changed ?
Date: 2001-02-28 04:28:03
Message-ID: 20010228095803.B1495@india-today.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-28 04:46:09 Re: [HACKERS] BLCKSZ 0?
Previous Message Anand Raman 2001-02-28 04:26:45 Re: joining databases