Re: last UPDATE or INSERT time of a table? - Mailing list pgsql-general

From Richard Huxton
Subject Re: last UPDATE or INSERT time of a table?
Date
Msg-id 000f01c09761$44b972c0$1001a8c0@archonet.com
Whole thread Raw
In response to last UPDATE or INSERT time of a table?  (Louis-David Mitterrand <cunctator@apartia.ch>)
Responses Re: last UPDATE or INSERT time of a table? (not a row!)  (Louis-David Mitterrand <cunctator@apartia.ch>)
List pgsql-general
From: "Louis-David Mitterrand" <cunctator@apartia.ch>

> Is there a way to check the last time a table was UPDATEd or INSERTEd?
> Is there a timestamp somewhere in the system tables?
>
> (If not that would be really useful to help in web page cacheing and
> expiration to learn if any change occured on the data)
>
> Thanks in advance,

You can set up a trigger. See my previous post RFC: automatic
"lastchange"... for some more info, or search the archives.

- Richard Huxton


pgsql-general by date:

Previous
From: Alfonso Peniche
Date:
Subject: Re: temp table creation
Next
From: Tom Lane
Date:
Subject: Re: Re: temp table creation