Postgres Pro
Downloads
Home   >   mailing lists

Re: Change stored procedures schema name - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Change stored procedures schema name
Date
Msg-id 20090806212230.GR7769@alvh.no-ip.org
Whole thread Raw
In response to Change stored procedures schema name  (Mainor Alonso Morales González<mmorales@ncq.co.cr>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Mainor Alonso Morales González
Date:
Subject: Change stored procedures schema name
Next
From: Mike angelo
Date:
Subject: CSV Utility