GaussDB-MY_PROCEDURES
MY_PROCEDURES displays information about stored procedures, functions, or triggers owned by the current user. This view exists in the PG_CATALOG and SYS schemas. This view can be accessed by all users. Only the information about the current user can be viewed.
| Name | Type | Description |
|---|---|---|
| owner | character varying(64) | Owner of a stored procedure, function, or trigger. |
| object_name | character varying(64) | Name of a stored procedure, function, or trigger. |
| procedure_name | character varying(128) | Not supported. Set it to NULL. |
| object_id | oid | OID of a stored procedure, function, or trigger. |
| subprogram_id | numeric | Not supported. Set it to NULL. |
| overload | character varying(40) | Nth overloaded function. |
| object_type | character varying(13) | Object type. |
| aggregate | character varying(3) | Specifies whether the function is an aggregate function:- YES |
- NO | | pipelined | character varying(3) | Not supported. Set it to NO. | | impltypeowner | character varying(128) | Owner of an implementation type. | | impltypename | character varying(128) | Name of an implementation type. | | parallel | character varying(3) | Not supported. Set it to NO. | | interface | character varying(3) | Not supported. Set it to NO. | | deterministic | character varying(3) | Not supported. Set it to NO. | | authid | character varying(12) | Specifies whether to use the creator permission or caller permission:- DEFINER: The creator permission is used.
- CURRENT_USER: The caller permission is used.This column conflicts with reserved keywords. Therefore, add the view name when calling this column. | | result_cache | character varying(3) | Not supported. Set it to NULL. | | origin_con_id | character varying(256) | Not supported. Set it to 0. | | polymorphic | character varying(5) | Not supported. Set it to NULL. | | argument_number | smallint | Number of input parameters in the stored procedure. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
