PostgreSQL 触发器

-- 查询触发器

select * from information_schema.triggers

-- 删除触发器

DROP TRIGGER example_trigger on t_sys_oper_log ;

-- 触发器

CREATE TRIGGER example_trigger AFTER INSERT ON t_sys_oper_log FOR EACH ROW EXECUTE PROCEDURE log_insert_trigger_fun();

--触发方法

CREATE OR REPLACE FUNCTION log_insert_trigger_fun() RETURNS TRIGGER AS $example_table$

   BEGIN

     if(new.issucc = '1') then

      INSERT INTO t_sys_abnormal(guid, modulecode,url) VALUES (cast(new.guid as INTEGER), new.modulecode,new.url);

        end if;

        RETURN NEW;

   END;

$example_table$ LANGUAGE plpgsql;