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-03 06:07:36
Message-ID: 001901c3b963$c07379c0$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 long queries by evaluating whether the data has been
changed since last query. What should I do?

-Jason

Browse pgsql-general by date

  From Date Subject
Next Message Ausrack Webmaster 2003-12-03 06:45:53 DBD::Pg problem
Previous Message Joe "Nuke Me Xemu" Foster 2003-12-03 04:22:24 Re: Making a tree with "millions and millions" of dynamic nodes