1、创建存储过程
CREATE OR REPLACE FUNCTION update_last_update_column()
RETURNS TRIGGER AS $$
BEGIN
NEW.update_time = NOW();
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
2、创建触发器并为触发器设置执行的存储过程
CREATE TRIGGER update_employee_modtime
BEFORE INSERT OR UPDATE
ON employees
FOR EACH ROW
EXECUTE PROCEDURE update_last_update_column();