Re: grant execute on many functions - Mailing list pgsql-admin

Joe Conway <mail@joeconway.com> writes:
> Jean-Denis Giguere wrote:
>> But, the problem is more complex for functions because you have to give
>> the arguments.

> Does this help?

> SELECT n.nspname || '.' || p.proname ||
>         '(' || pg_catalog.oidvectortypes(p.proargtypes) || ')'

Also, casting the function's OID to regprocedure may be useful.
Random example:

regression=# select 1142::regprocedure;
      regprocedure
------------------------
 date_mii(date,integer)
(1 row)

            regards, tom lane