Postgres Pro
Downloads
Home   >   mailing lists

Thread: Find out when a table was last changed ?

Find out when a table was last changed ?

From
Markus Fischer
Date:
Hi,
    Is there some kind of command or internal PostgreSql
column to find out when a table was last changed (INSERT, UPDATE
or DELETE) on a 7.0.2 Server ?

thanks,
    Markus

--
Markus Fischer,  http://josefine.ben.tuwien.ac.at/~mfischer/
EMail:         mfischer@josefine.ben.tuwien.ac.at
PGP Public  Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc
PGP Fingerprint: D3B0 DD4F E12B F911 3CE1  C2B5 D674 B445 C227 2BD0

Re: Find out when a table was last changed ?

From
Anand Raman
Date:
No u need to maintain this information in another column such as
last_update_date which your application should update everyt time u
perform any operation on it..

Hope this helps
Anand

On Wed, Feb 28, 2001 at 04:24:52AM +0100, Markus Fischer wrote:
>Hi,
>    Is there some kind of command or internal PostgreSql
>column to find out when a table was last changed (INSERT, UPDATE
>or DELETE) on a 7.0.2 Server ?
>
>thanks,
>    Markus
>
>--
>Markus Fischer,  http://josefine.ben.tuwien.ac.at/~mfischer/
>EMail:         mfischer@josefine.ben.tuwien.ac.at
>PGP Public  Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc
>PGP Fingerprint: D3B0 DD4F E12B F911 3CE1  C2B5 D674 B445 C227 2BD0

Re: Find out when a table was last changed ?

From
"Jonathan Ellis"
Date:
Better yet, define a trigger so you and/or other programmers don't have
to worry about including that field in every update.

-Jonathan

----- Original Message -----
From: Anand Raman <araman@india-today.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, February 27, 2001 8:28 PM
Subject: Re: Find out when a table was last changed ?


> No u need to maintain this information in another column such as
> last_update_date which your application should update everyt time u
> perform any operation on it..
>
> Hope this helps
> Anand
>
> On Wed, Feb 28, 2001 at 04:24:52AM +0100, Markus Fischer wrote:
> >Hi,
> > Is there some kind of command or internal PostgreSql
> >column to find out when a table was last changed (INSERT, UPDATE
> >or DELETE) on a 7.0.2 Server ?
> >
> >thanks,
> > Markus
> >
> >--
> >Markus Fischer,  http://josefine.ben.tuwien.ac.at/~mfischer/
> >EMail:         mfischer@josefine.ben.tuwien.ac.at
> >PGP Public  Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc
> >PGP Fingerprint: D3B0 DD4F E12B F911 3CE1  C2B5 D674 B445 C227 2BD0
>