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 CAKFQuwYLOipHt+=uto4RVyYaaJsYdLQFRDVF7Ct=WCFH7rvtqg@mail.gmail.com
Whole thread Raw
In response to Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER  (PABLO ANDRES IBARRA DUPRAT <Pablo.Ibarra@itau.cl>)
Responses RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
List pgsql-admin
Tree view
On Tuesday, June 18, 2024, PABLO ANDRES IBARRA DUPRAT <Pablo.Ibarra@itau.cl> wrote:

                                    Hi Dear Community.

 

                                               I need your help with advices about the way to script a SQL command to generate a list of ALTER PROCEDURE and change owner of a big number of procedures.

                                               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.

                                               Please any advice Will be appreciate.

 

                                        


Have you determined that “reassigned owned” won’t work for you?

David J.

pgsql-admin by date:

Previous
From: PABLO ANDRES IBARRA DUPRAT
Date:
Subject: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
Next
From: "David G. Johnston"
Date:
Subject: Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER