MY_PROCEDURES
MY_PROCEDURES displays information about stored procedures, functions, or triggers owned by the current user. This view exists in both PG_CATALOG and SYS schema. 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. Its value is NULL. |
| object_id | oid | OID of a stored procedure, function, or trigger. |
| subprogram_id | numeric | Not supported. Its value is NULL. |
| overload | character varying(40) | nth overloaded function of the name. |
| object_type | character varying(13) | Object type name. |
| aggregate | character varying(3) | Specifies whether the function is an aggregate function:
|
| pipelined | character varying(3) | Not supported. Its value is 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. Its value is NO. |
| interface | character varying(3) | Not supported. Its value is NO. |
| deterministic | character varying(3) | Not supported. Its value is NO. |
| authid | character varying(12) | Specifies whether to use the creator permission or caller permission:
This column conflicts with reserved keywords. Therefore, add the view name when calling this column. |
| result_cache | character varying(3) | Not supported. Its value is NULL. |
| origin_con_id | character varying(256) | Not supported. Its value is 0. |
| polymorphic | character varying(5) | Not supported. Its value is NULL. |
| argument_number | smallint | Number of input parameters in a stored procedure. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
