How to get table change time

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: How to get table change time
Date: 2005-08-16 14:21:05
Message-ID: ddssr0$2vs1$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

For table replication, I need to know the date and time when particular
table is last changed by insert, update or delete command.
This information is required for most tables in database (about 100 tables).

How to obtain this information without creating 100 triggers ?

Andrus.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-08-16 14:23:05 Re: Testing of MVCC
Previous Message Aly Dharshi 2005-08-16 14:20:49 Re: Postgresql Books: Which one ?