Postgres Pro
Downloads
Home   >   mailing lists

Recording Date,Time and UserId when a record is modified - Mailing list pgsql-sql

From Sue Hanen
Subject Recording Date,Time and UserId when a record is modified
Date
Msg-id 01BE6AFC.FD75A100@silver170-92.silverlink.net
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Dan Lauterbach
Date:
Subject: How match percent sign in SELECT using LIKE?
Next
From: secret
Date:
Subject: Re: [SQL] Re: How to optimize a query... -- Extreme performance difference, same EXPLAIN