Automatically updated a timestamp column using a trigger in PostgreSQL.

postgresql-update-timestamp-trigger.sql

CREATE OR REPLACE FUNCTION updated()
RETURNS TRIGGER AS $$
BEGIN
	NEW.updated = NOW();
	RETURN NEW;
END;
$$ LANGUAGE 'plpgsql';

CREATE TRIGGER updated BEFORE UPDATE ON projects FOR EACH ROW EXECUTE PROCEDURE updated();