Last modification time - Mailing list pgsql-general

From Johan Vromans
Subject Last modification time
Date
Msg-id m2mzgydko3.fsf@phoenix.squirrel.nl
Whole thread Raw
Responses Re: Last modification time  (Doug McNaught <doug@mcnaught.org>)
List 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

pgsql-general by date:

Previous
From: "Jim Buttafuoco"
Date:
Subject: Re: Adding pl/perl support
Next
From: Doug McNaught
Date:
Subject: Re: Last modification time