Hello Experts, I want to list all procedures and functions with their input & output parameter definitions in a CSV file. Looking at pg_catalog.pg_proc table, I see that the information about I/O parameters is spread out in columns: proargtypes --> Containing the OID for the data types proargnames --> Argument names Both of these columns are LOVs containing the data type OIDs and just names. Is it possible to list the parameters as a combined string (IN Name varchar, IN startdate date,OUT sal int)? 'prosrc' column has the function listing but nothing about parameters. Looked at the information_schema.routines view also but didn't anything there.
... View more