触发器函数

  • pg_get_triggerdef(oid)

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

    参数:待查触发器的OID。

    返回值类型:text

    示例:

    1. openGauss=# select pg_get_triggerdef(oid) from pg_trigger;
    2. pg_get_triggerdef
    3. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    4. CREATE TRIGGER tg1 BEFORE INSERT ON gtest26 FOR EACH STATEMENT EXECUTE PROCEDURE gtest_trigger_func()
    5. CREATE TRIGGER tg03 AFTER INSERT ON gtest26 FOR EACH ROW WHEN ((new.a IS NOT NULL)) EXECUTE PROCEDURE gtest_trigger_func()
    6. (2 rows)
  • pg_get_triggerdef(oid, boolean)

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

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

    触发器函数 - 图1 说明:

仅在创建trigger时指定WHEN条件的情况下,布尔类型参数才生效。

返回值类型:text

示例:

  1. ```
  2. openGauss=# select pg_get_triggerdef(oid,true) from pg_trigger;
  3. pg_get_triggerdef
  4. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  5. CREATE TRIGGER tg1 BEFORE INSERT ON gtest26 FOR EACH STATEMENT EXECUTE PROCEDURE gtest_trigger_func()
  6. CREATE TRIGGER tg03 AFTER INSERT ON gtest26 FOR EACH ROW WHEN (new.a IS NOT NULL) EXECUTE PROCEDURE gtest_trigger_func()
  7. (2 rows)
  8. openGauss=# select pg_get_triggerdef(oid,false) from pg_trigger;
  9. pg_get_triggerdef
  10. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  11. CREATE TRIGGER tg1 BEFORE INSERT ON gtest26 FOR EACH STATEMENT EXECUTE PROCEDURE gtest_trigger_func()
  12. CREATE TRIGGER tg03 AFTER INSERT ON gtest26 FOR EACH ROW WHEN ((new.a IS NOT NULL)) EXECUTE PROCEDURE gtest_trigger_func()
  13. (2 rows)
  14. ```