Quick Links

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

From:	"Andy Kriger" <akriger(at)greaterthanone(dot)com>
To:	"Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject:	how do i find out when a record was created/modified?
Date:	2002-11-21 23:07:06
Message-ID:	OJEFIHHAALOBKKJEOMBDKEKOCIAA.akriger@greaterthanone.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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()?

thx
andy

Responses

Re: how do i find out when a record was created/modified? at 2002-11-21 23:31:52 from Doug McNaught
Re: how do i find out when a record was created/modified? at 2002-11-22 10:12:56 from Oliver Elphick

Browse pgsql-general by date

	From	Date	Subject
Next Message	scott.marlowe	2002-11-21 23:07:20	Re: sequenc_name.currval not defined
Previous Message	MT	2002-11-21 22:54:11	sequenc_name.currval not defined