Results 1 to 3 of 3
May 19, 2004, 11:11 #1
postgresql default field value manipulation question
Is there a way to have a timestamp field in postgresql update to current date/time whenever there is a change to the record? I want to be able to change the date/time for tracking purposes. If I can do it at the table level that would be great.
Also, was wondering if it's necessary to specify a length for a timestamp field.
May 21, 2004, 10:35 #2
- Join Date
- Feb 2004
- 0 Post(s)
- 0 Thread(s)
You can use a trigger to perform the desired action on an update.
May 25, 2004, 04:48 #3
Do you know of any good sites that lists examples are tutorials on working with postgresql triggers?
Originally Posted by Stream