1.创建源表和触发表，在源表上创建insert触发器，创建操作触发表的触发器函数

omm=# CREATE TABLE test_trigger_src_tbl(id1 INT, id2 INT, id3 INT) ;
omm=# CREATE TABLE test_trigger_des_tbl(id1 INT, id2 INT, id3 INT);
omm=# CREATE OR REPLACE FUNCTION tri_insert_func() RETURNS TRIGGER AS
omm-# $$
omm$# DECLARE
omm$# BEGIN
omm$# INSERT INTO test_trigger_des_tbl VALUES(NEW.id1, NEW.id2, NEW.id3);
omm$# RETURN NEW;
omm$# END
omm$# $$ LANGUAGE PLPGSQL;
omm=# CREATE TRIGGER insert_trigger
omm-# BEFORE INSERT ON test_trigger_src_tbl
omm-# FOR EACH ROW
omm-# EXECUTE PROCEDURE tri_insert_func();

2.在源表上执行insert操作，查看触发操作是否生效；禁用触发器后，再次查看触发操作是否生效

omm=# INSERT INTO test_trigger_src_tbl VALUES(100,200,300);
omm=# SELECT * FROM test_trigger_src_tbl;
SELECT * FROM test_trigger_des_tbl;
omm=# ALTER TABLE test_trigger_src_tbl DISABLE TRIGGER insert_trigger;
omm=# insert into test_trigger_src_tbl values (600,700,800);
omm=# SELECT * FROM test_trigger_src_tbl;
omm=# SELECT * FROM test_trigger_des_tbl;

3.使用系统表PG_TRIGGER和\dS+查看触发器

omm=# select * from PG_TRIGGER;
omm=# \dS+ test_trigger_src_tbl

4.重命名触发器

omm=# alter trigger insert_trigger on test_trigger_src_tbl rename to insert_trigger_renamed;

5.删除触发器

omm=# drop trigger insert_trigger_renamed on test_trigger_src_tbl;