数据仓库服务 GAUSSDB(DWS)-触发器函数:pg_get_triggerdef(oid)

时间:2024-01-26 16:15:17

pg_get_triggerdef(oid)

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

参数:待查触发器的OID。

返回值类型:text

示例:

1
2
3
4
5
SELECT pg_get_triggerdef(oid) FROM pg_trigger;
                                                  pg_get_triggerdef
----------------------------------------------------------------------------------------------------------------------
 CREATE TRIGGER insert_trigger BEFORE INSERT ON test_trigger_src_tbl FOR EACH ROW EXECUTE PROCEDURE tri_insert_func()
(1 row)
support.huaweicloud.com/sqlreference-820-dws/dws_06_0066.html