触发器函数

• 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方式展示。

说明：

仅在创建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)

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