PG触发器

2020-06-15  本文已影响0人  秋收拖拉机

CREATE OR REPLACE FUNCTION dljck_history() RETURNS TRIGGER AS dljck_stamp
BEGIN
insert into dljck_history (gid,id,fldm,gbdm,mc,type ,gxdwdm ,gxsj ,szdl ,ssqy ,geom ) values (new.gid,new.id,new.fldm,new.gbdm,new.mc,new.type ,new.gxdwdm ,new.gxsj ,new.szdl ,new.ssqy ,new.geom );
RETURN NEW;
END;
dljck_stamp LANGUAGE plpgsql;

CREATE TRIGGER dljck_stamp AFTER INSERT ON dljck
FOR EACH ROW EXECUTE PROCEDURE dljck_history();

上一篇 下一篇

猜你喜欢

热点阅读