proc

The m_schema.proc view displays information about GaussDB stored procedures.

This view is read-only. All users have the read permission on this view, but they can read only the records that they have the access permission.

**Table 1** m_schema.proc columns
Name	Type	Description
db	char(64)	Name of the database (schema).
name	char(64)	Name of the routine.
specific_name	char(64)	Exact name of the routine.
param_list	blob	List of parameters.
returns	longblob	Return value type of the routine. The value is array, user_defined, or others.
body	longblob	Definition of the routine.
definer	char(93)	User who defines the routine.
created	timestamp	Date and time when the routine is created. Not supported. It is always null.
modified	timestamp	Date and time when the routine is modified. Not supported. It is always null.
comment	text	Not supported. It is always null.
character_set_client	char(32)	Character set used by the client that creates the routine.
collation_connection	char(32)	Collation (and character set) used to create routine connections. Not supported. It is always null.
db_collation	char(32)	Default collation (and character set) of the database when the routine is created. Not supported. It is always null.
body_utf8	longblob	Definition of the routine (UTF-8). Not supported. It is always null.

In M-compatible databases of the current version, the type, language, sql_data_access, is_deterministic, security_type, and sql_mode columns are not displayed in this view.

Parent topic: m_schema

Previous topic: procs_priv

Next topic: func