Last modification time

From: Johan Vromans <jvromans(at)squirrel(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Last modification time
Date: 2006-02-11 14:39:24
Message-ID: m2mzgydko3.fsf@phoenix.squirrel.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

For a big application, I want to generate reports from the database and
keep these on-line as long as they reflect the actual contents of the
database. I only want to regenerate the reports when needed, i.e.,
when the database contents have changed.

I'm sure PostgreSQL can tell me when the last update has been
COMMITted but until now I haven't been able to find out how. I must
have used the wrong search terms...

Can anyone tell me how to find the last update time of a database?

Thanks,
Johan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2006-02-11 14:52:39 Re: Last modification time
Previous Message Jim Buttafuoco 2006-02-11 14:07:29 Re: Adding pl/perl support