Skip site navigation (1) Skip section navigation (2)

Last insert/update/delete time for a table

From: Aleksander Kmetec - INTERA <aleksander(dot)kmetec(at)intera(dot)si>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Last insert/update/delete time for a table
Date: 2008-04-25 12:14:17
Message-ID: 4811CB19.9090500@intera.si (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-general by date

Next:From: Roberts, JonDate: 2008-04-25 12:47:06
Subject: pg_version is missing
Previous:From: Tino WildenhainDate: 2008-04-25 12:11:13
Subject: Re: How to modify ENUM datatypes?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group