Skip site navigation (1) Skip section navigation (2)

Re: Last access time for a table

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 (view raw or flat)
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
**********************



In response to

Responses

pgsql-novice by date

Next:From: Muhammad Shariq MuzaffarDate: 2003-03-12 18:19:03
Subject: Re: create function pl/pgsql c langauge
Previous:From: Bruno Wolff IIIDate: 2003-03-12 16:55:04
Subject: Re: SERIAL does not ROLLBACK

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group