Re: Generating GRANT/REVOKE on functions from catalog

That looks like exactly what I want. Is there an easy way to cast that
to a string so that I can concatenate it into a GRANT statement?

------------------------------------------------------------------------
*Doug Gorley* | doug(dot)gorley(at)gmail(dot)com <mailto:doug(dot)gorley(at)gmail(dot)com>

Tom Lane wrote:
> Doug Gorley <doug(dot)gorley(at)gmail(dot)com> writes:
>
>> The statement I need to generate is:
>>
>
>
>> revoke all on function public.add(integer, integer) from someuser;
>>
>
>
>> I'm attempting to use the pg_proc table in the system catalogs, and I'm
>> good up to the point where I need the parameter types. Can anyone give
>> me a hand with this?
>>
>
> Personally, I'd cast the function OID to regprocedure, instead of
> doing it the hard way ...
>
> regards, tom lane
>