云数据库 GAUSSDB-系统表信息函数:pg_get_functiondef(func_oid)

时间:2025-06-03 09:32:37

pg_get_functiondef(func_oid)

描述:获取函数的定义。

返回类型:text

示例:
gaussdb=# SELECT * FROM pg_get_functiondef(598);
 headerlines |                     definition                     
-------------+----------------------------------------------------
           4 | CREATE OR REPLACE FUNCTION pg_catalog.abbrev(inet)+
             |  RETURNS text                                     +
             |  LANGUAGE internal                                +
             |  IMMUTABLE STRICT NOT FENCED NOT SHIPPABLE        +
             | AS $function$inet_abbrev$function$                +
             | 
(1 row)
support.huaweicloud.com/distributed-devg-v8-gaussdb/gaussdb-12-2655.html