Postgres Pro
Downloads
Home   >   mailing lists

Re: Last access time for a table - Mailing list pgsql-novice

From Aarni Ruuhimäki
Subject Re: Last access time for a table
Date
Msg-id 200303121922.04022.aarni.ruuhimaki@kymi.com
Whole thread Raw
In response to Last access time for a table  (Jonathon Batson <jonathon@octahedron.com.au>)
List pgsql-novice
Tree view 
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@kymi.com / aarni.ruuhimaki@kymi.com

05 - 3755 035 / 050 - 4910 037

**********************
Linux RedHat / KDE
**********************

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: SERIAL does not ROLLBACK
Next
From: Muhammad Shariq Muzaffar
Date:
Subject: Re: create function pl/pgsql c langauge