last update time of a table

From: "pg" <pg(at)newhonest(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: last update time of a table
Date: 2003-12-05 01:21:56
Message-ID: 008801c3bace$2c51e620$2101a8c0@jasonnb
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any simple way to query the most recent time of "changes" made to a
table?

I'm accessing my database with ODBC to a remote site thru internet. I want
to eliminate some DUPLICATE long queries by evaluating whether the data has
been
changed since last query. What should I do?

-Jason

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roderick A. Anderson 2003-12-05 01:23:42 Groups vs. Roles
Previous Message Mike Mascari 2003-12-05 01:01:32 Re: are cursors necessary?