Re: last UPDATE or INSERT time of a table? (not a row!) - Mailing list pgsql-general

From Louis-David Mitterrand
Subject Re: last UPDATE or INSERT time of a table? (not a row!)
Date
Msg-id 20010216091052.A6320@apartia.ch
Whole thread Raw
In response to Re: last UPDATE or INSERT time of a table? (not a row!)  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
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 h�rit� ;
            Il ne me traitait point comme une criminelle.
                                          (Ph�dre, J-B Racine, acte 5, sc�ne 3)

pgsql-general by date:

Previous
From: Frank Joerdens
Date:
Subject: Re: Re: PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?
Next
From: "Mikhail V. Majorov"
Date:
Subject: function likes sprintf