创建触发器函数
CREATE OR REPLACE FUNCTION "public"."insert_test_funcs"()
RETURNS "pg_catalog"."trigger" AS $BODY$
BEGIN
insert into test2 (a,b,c)
VALUES (new.a,new.b,new.c);
RETURN NEW;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
创建触发器
CREATE TRIGGER "createbh_test_insert_trigger" AFTER INSERT ON "public"."test"
FOR EACH ROW
EXECUTE PROCEDURE "public"."insert_test_funcs"();