MY_PROCEDURES

DEFINER: The creator permission is used.
CURRENT_USER: The caller permission is used.

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.

**Table 1** MY_PROCEDURES columns
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: YES NO
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: 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. 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 the stored procedure.