Re: How Do I Find the Date When A Table Was Last Changed?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: How Do I Find the Date When A Table Was Last Changed?
Дата
Msg-id dcc563d10810271643u15f00766u9fae1608e9a6a58c@mail.gmail.com
обсуждение исходный текст
Ответ на How Do I Find the Date When A Table Was Last Changed?  (Bill Thoen <bthoen@gisnet.com>)
Список pgsql-general
Дерево обсуждения 
On Mon, Oct 27, 2008 at 4:02 PM, Bill Thoen <bthoen@gisnet.com> wrote:
> Is there a way to find when data in a postgresql table was last changed?

what do you mean by changed?  Data updated?  schema changed?
PostgreSQL provides neither by default really.  You could set up an
update trigger to handle the issue of data being changed.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL 8.3.3 chooses wrong query plan when LIMIT 1 added?
Следующее
От: Bruno Baguette
Дата:
Сообщение: Re: [PLPGSQL] PERFORM into an EXECUTE allowed ?