sys.procedure

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)