首先,要建 立过程语言,比如plpgsql,这个文档中有, 然后建立实现触发器的函数, 最后建立触发器CREATE FUNCTION test_tigger_fun() RETURNS trigger AS ' BEGIN insert into tb2 values (new.field1,new.field2.....); RETURN NEW; END; ' LANGUAGE 'plpgsql';CREATE TRIGGER tb1_trigger AFTER INSERT ON tb1 FOR EACH ROW EXECUTE PROCEDURE test_tigger_fun();现在没问题了吧!
然后建立实现触发器的函数,
最后建立触发器CREATE FUNCTION test_tigger_fun() RETURNS trigger AS '
BEGIN
insert into tb2 values (new.field1,new.field2.....);
RETURN NEW;
END;
' LANGUAGE 'plpgsql';CREATE TRIGGER tb1_trigger AFTER INSERT ON tb1
FOR EACH ROW EXECUTE PROCEDURE test_tigger_fun();现在没问题了吧!