Re: last UPDATE or INSERT time of a table?

From: "Richard Huxton" <dev(at)archonet(dot)com>
To: "Louis-David Mitterrand" <cunctator(at)apartia(dot)ch>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: last UPDATE or INSERT time of a table?
Date: 2001-02-15 15:09:16
Message-ID: 000f01c09761$44b972c0$1001a8c0@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: "Louis-David Mitterrand" <cunctator(at)apartia(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-15 15:12:10 Re: Max query limit in 7.1? With TOAST?
Previous Message Kristoffer Hoffe Bergqvist 2001-02-15 15:06:40 DSN-less connection to Postgres-database