Postgres Pro
Downloads
Home   >   mailing lists

Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
Date
Msg-id CAKFQuwY4xtq=M6x2g2BLTgnjvgO=_7ORDF4gnuYX8w4J7eLLcA@mail.gmail.com
Whole thread Raw
In response to Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
List pgsql-admin
Tree view
On Tue, Jun 18, 2024 at 12:42 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tuesday, June 18, 2024, PABLO ANDRES IBARRA DUPRAT <Pablo.Ibarra@itau.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.

                                             



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.

pgsql-admin by date:

Previous
From: PABLO ANDRES IBARRA DUPRAT
Date:
Subject: RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
Next
From: Tom Lane
Date:
Subject: Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER