Database Reference
In-Depth Information
CREATE TRIGGER changestamp
BEFORE UPDATE ON modify_test
FOR EACH ROW
EXECUTE PROCEDURE changestamp();
Now, let's take a look at our newly created trigger:
postgres=# INSERT INTO modify_test(data)
VALUES('something');
INSERT 0 1
postgres=# UPDATE modify_test SET data =
'something else' WHERE id = 1;
UPDATE 1
postgres=# SELECT * FROM modify_test; -[ RECORD
1 ]---+---------------------------
id | 1
data | something else
created_by | postgres
created_at | 2013-04-15 09:28:23.966179
last_changed_by | postgres
last_changed_at | 2013-04-15 09:28:31.937196
