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.gorley@gmail.com <mailto:doug.gorley@gmail.com>


Tom Lane wrote:
> Doug Gorley <doug.gorley@gmail.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
>