Determining when db last updated

Started by CSNalmost 22 years ago2 messagesgeneral
Jump to latest
#1CSN
cool_screen_name90001@yahoo.com

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

#2Duane Lee - EGOVX
DLee@mail.maricopa.gov
In reply to: CSN (#1)
Re: Determining when db last updated

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