title: How to get the list of functions in database in PostgreSQL along with its parameters?
body: <p>I have a database which has over 1000 functions. I want to GRANT execution permission to certain users. I can't do it manually, therefore I want to get a list of functions and write a code to generate the GRANT EXECUTE script for all the functions. I tried the following script but this is not giving me the parameters. I am unable to get the parameters with this query.</p>
  
  <pre><code>SELECT  'GRANT EXECUTE ON FUNCTION '||nspname||'.'||proname||' TO gis;'
  FROM    pg_catalog.pg_namespace n
  JOIN    pg_catalog.pg_proc p
  ON      pronamespace = n.oid
  WHERE   nspname = 'ccdb'
  </code></pre>
  
  <p>How can I get my desired result with the datatypes?</p>
  
  <p>Like,</p>
  
  <pre><code>GRANT EXECUTE ON FUNCTION &lt;schema_name&gt;.&lt;table_name&gt;(&lt;list of arguments&gt;) TO &lt;user_name&gt;;
  </code></pre>