Last modification time

Поиск
Список
Период
Сортировка
От Johan Vromans
Тема Last modification time
Дата
Msg-id m2mzgydko3.fsf@phoenix.squirrel.nl
обсуждение исходный текст
Ответы Re: Last modification time  (Doug McNaught <doug@mcnaught.org>)
Список 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 по дате отправления:

Предыдущее
От: "Jim Buttafuoco"
Дата:
Сообщение: Re: Adding pl/perl support
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: Last modification time