| From: | Duane Lee - EGOVX <DLee(at)mail(dot)maricopa(dot)gov> |
|---|---|
| To: | "'CSN'" <cool_screen_name90001(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Determining when db last updated |
| Date: | 2004-07-06 21:55:47 |
| Message-ID: | 64EDC403A1417B4299488BAE87CA7CBF01CD0EB3@maricopa_xcng0 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)yahoo(dot)com]
Sent: Tuesday, July 06, 2004 2:06 PM
To: pgsql-general(at)postgresql(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2004-07-06 22:01:24 | Re: [GENERAL] Do we need more emphasis on backup? |
| Previous Message | CSN | 2004-07-06 21:06:12 | Determining when db last updated |