postgresql通过触发器实现a表插入一条数据时，b表同时插入一条数据

创建触发器函数

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"();