Last insert/update/delete time for a table

Поиск
Список
Период
Сортировка
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 по дате отправления:

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: How to modify ENUM datatypes?
Следующее
От: "Roberts, Jon"
Дата:
Сообщение: pg_version is missing