Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER

On Tue, Jun 18, 2024 at 12:42 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tuesday, June 18, 2024, PABLO ANDRES IBARRA DUPRAT <
> Pablo(dot)Ibarra(at)itau(dot)cl> wrote:
>
>>
>>
>> As you know to identify
>> the procedure or function is neccesary to add to the name of routine and
>> list of parameters with their data type in each case.
>>
>>
>>
>>
> See
> https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-OBJECT
>
> pg_identify_object
>
>
>
Specifically:

select id.*, pg_proc.*, tableoid from pg_proc,
pg_identify_object(1255,oid,0) as id;

type | function
schema | public
name |
identity | public."i.am.a.function"(pg_catalog.text,integer)
oid | 16389
proname | i.am.a.function
[...]

David J.