Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Jun 18, 2024 at 12:42 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Tuesday, June 18, 2024, PABLO ANDRES IBARRA DUPRAT <Pablo.Ibarra@xxxxxxx> 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.