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

Поиск
Список
Период
Сортировка
От David Goodenough
Тема Re: how do i find out when a record was created/modified?
Дата
Msg-id 20021122112709.7E3B6475AE6@postgresql.org
обсуждение исходный текст
Ответ на Re: how do i find out when a record was created/modified?  (Oliver Elphick <olly@lfix.co.uk>)
Ответы Re: how do i find out when a record was created/modified?  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Re: how do i find out when a record was created/modified?  (Oliver Elphick <olly@lfix.co.uk>)
Список pgsql-general
On Friday 22 November 2002 10:12, Oliver Elphick wrote:
> On Thu, 2002-11-21 at 23:07, Andy Kriger wrote:
> > 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()?
>
> Defaulting to now() will only track inserts, not updates.
>
> There is a contrib module, spi/moddatetime, that will do both.

I just went to the web site, and from there to the FTP master and looked
in the contrib directory, and its empty.  Presuming I looked in the wrong
place could you give us a URL please?

David

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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: How to know and change the owner of a table in psql ?
Следующее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: how do i find out when a record was created/modified?