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.
owner_id	bigint	Unique ID of the user who owns the view. Join to sys.user to get the name of the user.
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)