Product DocumentationAppearance
sys.procedure
A system view that returns information about the user-defined stored procedures in the database.
| Column Name | Data Type | Description |
|---|---|---|
| procedure_id | bigint | Unique ID of the stored procedure. |
| database_id | bigint | Unique ID of the database where the procedure was created. |
| schema_id | bigint | Unique ID of the schema where the view was created. Join to sys.schema to get the schema name. |
| name | text | Name of the stored procedure. |
| definition | text | Signature of the stored procedure, including the data type of each parameter. |
| creation_time | timestamptz | When the procedure was created. |
| database_name | text | Name of the database where the procedure was created. |
For example:
premdb=# select * from sys.procedure; procedure_id | database_id | schema_id | name | definition | creation_time | database_name
--------------+-------------+-----------+-----------------+---------------------------------------------+-------------------------------+---------------
19120 | 16395 | 2200 | addteam | addteam(character varying) | 2020-02-17 20:42:52.749904-08 | premdb
19121 | 16395 | 2200 | insert_hometeam | insert_hometeam(integer, character varying) | 2020-02-17 20:43:03.993084-08 | premdb
(2 rows)Parent topic:System Views