title: How to list out the user defined functions and procedures in PostgreSQL
body: <p>Trying to find out the stored functions and procedures on PostgreSQL. I found some of the solutions where "join" has been used. I am looking for an optimal solution/command to it.</p>