触发器函数

    • 描述：获取触发器的定义信息。

      参数：待查触发器的OID。

      示例:

    • pg_get_triggerdef(oid, boolean)

      参数：待查触发器的OID及是否以pretty方式展示。

      示例:

      2.                                                                                      pg_get_triggerdef
      3.  CREATE TRIGGER tg1 BEFORE INSERT ON gtest26 FOR EACH STATEMENT EXECUTE PROCEDURE gtest_trigger_func()
      5. (2 rows)
      8. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      9.  CREATE TRIGGER tg1 BEFORE INSERT ON gtest26 FOR EACH STATEMENT EXECUTE PROCEDURE gtest_trigger_func()
      10.  CREATE TRIGGER tg03 AFTER INSERT ON gtest26 FOR EACH ROW WHEN ((new.a IS NOT NULL)) EXECUTE PROCEDURE gtest_trigger_func()