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

From: CoL <col(at)mportal(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how do i find out when a record was created/modified?
Date: 2002-11-22 21:12:24
Message-ID: arm683$b55$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)greaterthanone(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Frank Bax 2002-11-22 21:15:45 index vs seqscan question
Previous Message Tom Jenkins 2002-11-22 20:53:19 Seeking PostgreSQL DBA/programmer