Thanks and Yes, I thought of that as well. My question should really be....
Is there a postgresql system table or function that holds/records the last data/time a table has been accessed or updated?
Thanks
Jonathon
Aarni Ruuhimäki wrote:
Hi !
How about a column 'last_updated' which gets a fresh date/time on every update
and then a view, if you like, to show max(last_updated) on your tables?
BR,
aarni
On Wednesday 12 March 2003 07:24, you wrote:
Hi..
I would like to be able to find out when the last time a table has been
accessed or updated.
Can this be done?
Thanks
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster