Re: timestamp of a row - Mailing list pgsql-novice

From Mladen Gogala
Subject Re: timestamp of a row
Date
Msg-id 4BFA72D2.9090508@vmsinfo.com
Whole thread Raw
In response to timestamp of a row  (Marco Bomben <marco.bomben@gmail.com>)
List pgsql-novice
Marco Bomben wrote:
> Dear all,
>              I look into mails-archive but I didn't find any hint for
> this question: is there a way to retrieve the timestamp of the
> creation/last modification of a row in a table?
Of course there is. You should create an auditing trigger to record the
time of the modification, the primary key of the row that was modified
and the nature of the modification itself.

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com


pgsql-novice by date:

Previous
From: Marco Bomben
Date:
Subject: Re: timestamp of a row
Next
From: Joshua Tolley
Date:
Subject: Re: Sphinx indexing problem