From: Mainor Alonso Morales González Subject: [ADMIN] Change stored procedures schema nameTo: pgsql-admin@postgresql.orgDate: Thursday, August 6, 2009, 8:23 PM
There exist any way to change the name of my stored procedures schemas
but the code used inside of them???
for example:
I have this stor
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 co
There exist any way to change the name of my stored procedures schemas
but the code used inside of them???
for example:
I have this stored procedure:
CREATE OR REPLACE FUNCTION schema1.example(double precision) RETURNS
numeric AS
$BODY$
DECLARE
pIn ALIAS FOR $1;
BEGIN
insert in
