Postgres Pro
Downloads
Home   >   mailing lists

how do i find out when a record was created/modified? - Mailing list pgsql-general

From Andy Kriger
Subject how do i find out when a record was created/modified?
Date
Msg-id OJEFIHHAALOBKKJEOMBDKEKOCIAA.akriger@greaterthanone.com
Whole thread Raw
Responses Re: how do i find out when a record was created/modified?  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: MT
Date:
Subject: sequenc_name.currval not defined
Next
From: Philip Hallstrom
Date:
Subject: Re: sequenc_name.currval not defined