1.创建源表和触发表，在源表上创建insert触发器，创建操作触发表的触发器函数
CREATE TABLE src_tb1(a int, b int, c int);
CREATE TABLE des_tb2(a int, b int, c int);
CREATE OR REPLACE FUNCTION trigger_insert_des_func() RETURNS TRIGGER AS
$$
DECLARE
BEGIN
INSERT INTO des_tb2 VALUES(NEW.a, NEW.b, NEW.c);
RETURN NEW;
END
$$ LANGUAGE PLPGSQL;
CREATE TRIGGER insert_trigger_src
BEFORE INSERT ON src_tb1
FOR EACH ROW
EXECUTE PROCEDURE trigger_insert_des_func();
2.在源表上执行insert操作，查看触发操作是否生效；禁用触发器后，再次查看触发操作是否生效
INSERT INTO src_tb1 VALUES(100,200,300);
INSERT INTO src_tb1 VALUES(100,200,300);
INSERT INTO src_tb1 VALUES(100,200,300);
–查看触发操作生效
SELECT * FROM src_tb1;
SELECT * FROM des_tb2;
ALTER TABLE src_tb1 DISABLE TRIGGER insert_trigger_src;
–查看触发操作没有生效
SELECT * FROM src_tb1;
SELECT * FROM des_tb2;
3.使用系统表PG_TRIGGER和\dS+查看触发器
\dS+ src_tb1
select * from PG_TRIGGER;
4.重命名触发器
ALTER TRIGGER insert_trigger_src ON src_tb1 RENAME TO insert_tigger_src_tb1_001;
select * from PG_TRIGGER;
\dS+ src_tb1
5.删除触发器
DROP TRIGGER insert_tigger_src_tb1_001 ON src_tb1;
