From: | Jonathon Batson <jonathon(at)octahedron(dot)com(dot)au> |
---|---|
To: | Postgres Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Last access time for a table |
Date: | 2003-03-19 04:09:51 |
Message-ID: | 3E77ED8F.2000907@octahedron.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
>>
>>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2003-03-19 04:17:14 | Re: Problems using palloc in postgresql user C functions |
Previous Message | John Gunther | 2003-03-19 03:08:07 | Problems using palloc in postgresql user C functions |