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

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Andy Kriger" <akriger(at)greaterthanone(dot)com>
Cc: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: how do i find out when a record was created/modified?
Date: 2002-11-21 23:31:52
Message-ID: m3heeaijo7.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wright, Ryan P 2002-11-21 23:34:40 Re: Request assistance connecting with Pg::connectdb
Previous Message Philip Hallstrom 2002-11-21 23:07:35 Re: sequenc_name.currval not defined