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
>