Re: last UPDATE or INSERT time of a table? (not a row!)

On Thu, Feb 15, 2001 at 04:45:02PM -0500, Joseph Shraibman wrote:
> > Yes, I have read that thread qnd implemented a similar trigger in the
> > past.
> >
> > What I meant to do is detect a change at the _table_ level, not the row
> > level. Is there such a field somewhere in the pg_tables?
> >
>
> You could check the date on the file. But a vacuum might alter that.

Hmm, I see many files in /var/lib/postgres/data/base but how do I
recognize which file contains what table?

--
ARICIE: De votre injuste haine il n'a pas hrit ;
Il ne me traitait point comme une criminelle.
(Phdre, J-B Racine, acte 5, scne 3)