ADM_PROCEDURES

ADM_PROCEDURES displays information about all stored procedures, functions, and triggers in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** ADM_PROCEDURES columns
Name	Type	Description
owner	character varying(64)	Owner of a stored procedure, function, trigger, or package
object_name	character varying(64)	Name of a stored procedure, function, or trigger. This column will be a package name if the object is a function in a package or a stored procedure.
procedure_name	character varying(128)	This column will be the name of a function or stored procedure in a package if object_name is a package name. Otherwise, the column is empty.
object_id	oid	OID of a stored procedure, function, trigger, or package
subprogram_id	numeric	Location of a function or stored procedure in a package.
overload	character varying(40)	Nth overloaded function.
object_type	character varying(13)	Object class.
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)	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 a stored procedure