Last insert/update/delete time for a table - Mailing list pgsql-general

From Aleksander Kmetec - INTERA
Subject Last insert/update/delete time for a table
Date
Msg-id 4811CB19.9090500@intera.si
Whole thread Raw
Responses Re: Last insert/update/delete time for a table  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Last insert/update/delete time for a table  (Richard Huxton <dev@archonet.com>)
Re: Last insert/update/delete time for a table  ("Fujii Masao" <masao.fujii@gmail.com>)
List pgsql-general
Hi all,

I'm in the process of writing a backup script which only dumps those tables which were changed in the last 24 hours. We

have hundreds of tables (one per user), but most of them don't get changed very often, so there's no point in dumping
them every night.

Is there a way to get the time of the last insert, update or delete statement for a specific table?

Regards,
Aleksander

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: How to modify ENUM datatypes?
Next
From: "Roberts, Jon"
Date:
Subject: pg_version is missing