last UPDATE or INSERT time of a table?

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: last UPDATE or INSERT time of a table?
Date: 2001-02-15 15:00:07
Message-ID: 20010215160007.A4169@apartia.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,
--
HIPPOLYTE: Mais si quelque vertu m'est tombe en partage,
Seigneur, je crois surtout avoir fait clater
La haine des forfaits qu'on ose m'imputer.
(Phdre, J-B Racine, acte 4, scne 2)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kristoffer Hoffe Bergqvist 2001-02-15 15:06:40 DSN-less connection to Postgres-database
Previous Message Guillaume Lémery 2001-02-15 14:59:21 .TO_CHAR problem