Select Code to Download

createlang -U postgres -P <password> plpgsql <dbname>

CREATE FUNCTION timestamp_row () RETURNS OPAQUE AS '
    BEGIN
...
        RETURN NEW;
    END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER timestamp_session BEFORE INSERT OR UPDATE ON sessions
  FOR EACH ROW EXECUTE PROCEDURE timestamp_row();

ALTER TABLE sessions ADD COLUMN timestamp timestamp;
ALTER TABLE sessions ALTER COLUMN timestamp SET DEFAULT CURRENT_TIMEST
+AMP;