Re: how do i find out when a record was created/modified?

Поиск
Список
Период
Сортировка
От CoL
Тема Re: how do i find out when a record was created/modified?
Дата
Msg-id arm683$b55$1@news.hub.org
обсуждение исходный текст
Ответ на Re: how do i find out when a record was created/modified?  (Doug McNaught <doug@mcnaught.org>)
Список pgsql-general
And he can use triggers or the moddatetime from contrib.
C.

Doug McNaught wrote, On 11/22/2002 12:31 AM:
> "Andy Kriger" <akriger@greaterthanone.com> writes:
>
>> if i have a table full of data, is there metadata stored somewhere by psql
>> that can tell me when each record was created/modified? or do i have to
>> track this manually with datetime columns that default to now()?
>
> You have to track it manually.
>
> -Doug
>


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

Предыдущее
От: Hans-Jürgen Schönig
Дата:
Сообщение: Re: Question about DEADLOCK
Следующее
От: "Romel Tarin"
Дата:
Сообщение: trigger function