codekingpro/portable-devtools

1DROP TABLE mdt;2 3CREATE TABLE mdt (4	id		int4,5	idesc		text,6	moddate timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL7);8 9CREATE TRIGGER mdt_moddatetime10	BEFORE UPDATE ON mdt11	FOR EACH ROW12	EXECUTE PROCEDURE moddatetime (moddate);13 14INSERT INTO mdt VALUES (1, 'first');15INSERT INTO mdt VALUES (2, 'second');16INSERT INTO mdt VALUES (3, 'third');17 18SELECT * FROM mdt;19 20UPDATE mdt SET id = 421	WHERE id = 1;22UPDATE mdt SET id = 523	WHERE id = 2;24UPDATE mdt SET id = 625	WHERE id = 3;26 27SELECT * FROM mdt;28