| From: | Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com> |
|---|---|
| To: | jonathon(at)octahedron(dot)com(dot)au |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Last access time for a table |
| Date: | 2003-03-12 17:22:04 |
| Message-ID: | 200303121922.04022.aarni.ruuhimaki@kymi.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
--
Aarni Ruuhimäki
Megative Tmi
KYMI.com
Pääsintie 26
45100 Kouvola
info(at)kymi(dot)com / aarni(dot)ruuhimaki(at)kymi(dot)com
05 - 3755 035 / 050 - 4910 037
**********************
Linux RedHat / KDE
**********************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Muhammad Shariq Muzaffar | 2003-03-12 18:19:03 | Re: create function pl/pgsql c langauge |
| Previous Message | Bruno Wolff III | 2003-03-12 16:55:04 | Re: SERIAL does not ROLLBACK |