Re: Change stored procedures schema name

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Mainor Alonso Morales González <mmorales(at)ncq(dot)co(dot)cr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Change stored procedures schema name
Date: 2009-08-06 21:22:30
Message-ID: 20090806212230.GR7769@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mainor Alonso Morales González wrote:
> There exist any way to change the name of my stored procedures
> schemas but the code used inside of them???

No. You could try doing an UPDATE to pg_proc with a query that changed
the old schema for the new.

> sorry about my bad english :S

Perhaps you could use the pgsql-es-ayuda list, in any case. (Your
english does not seem all that bad anyway).

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mike angelo 2009-08-06 21:27:22 CSV Utility
Previous Message Mainor Alonso Morales González 2009-08-06 20:23:53 Change stored procedures schema name