Find out when a table was last changed ?

From: Markus Fischer <mfischer(at)josefine(dot)ben(dot)tuwien(dot)ac(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: Find out when a table was last changed ?
Date: 2001-02-28 03:24:52
Message-ID: 20010228042451.A5784@josefine.ben.tuwien.ac.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)josefine(dot)ben(dot)tuwien(dot)ac(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2001-02-28 03:29:22 Re: Re: vacuum and backup
Previous Message Thomas Lockhart 2001-02-28 03:18:20 Re: Query precompilation?