An audit trigger, at least that's what I call it, could be set up to do this for you.
Duane
-----Original Message-----
From: CSN [mailto:cool_screen_name90001@yahoo.com]
Sent: Tuesday, July 06, 2004 2:06 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Determining when db last updated
Would it be possible to determine the last time data
in a database was added/updated/deleted? Whether via
checking the system catalogs, creating a trigger, or
something else?
CSN
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org