Recording Date,Time and UserId when a record is modified

From: Sue Hanen <shanen(at)silverlink(dot)net>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Recording Date,Time and UserId when a record is modified
Date: 1999-03-10 21:49:11
Message-ID: 01BE6AFC.FD75A100@silver170-92.silverlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi

When a record has been modified, I would like a field on that record updated with the date and time. Do I use TIMESTAMP? How do I set this up?

Is is possible to update this same record with the user ID of the person who modified it? How can I do this?

Thanks much
Sue

Browse pgsql-sql by date

  From Date Subject
Next Message Dan Lauterbach 1999-03-10 21:58:01 How match percent sign in SELECT using LIKE?
Previous Message Thomas Reinke 1999-03-10 21:09:56 Re: [HACKERS] Bug on complex subselect (was: Bug on complex join)