## step1:创建触发器
CREATE OR REPLACE FUNCTION "upd_timestamp"()
RETURNS TRIGGER AS $$
BEGIN
NEW.updated_time = now(); # updated_time 为自动更新的字段,如果你创建字段的时候有带双引号,该字段也需带上双引号
RETURN NEW;
END;
$$ language 'plpgsql';
## step2:创建表
CREATE TABLE users (
id serial not null,
hometown varchar(100),
school varchar(200),
updated_time timestamp without time zone DEFAULT now()
)
## step3:在表中添加对应的触发器
CREATE TRIGGER "updated_time" BEFORE UPDATE ON "users"
FOR EACH ROW
EXECUTE PROCEDURE "upd_timestamp"();
网友评论