Change stored procedures schema name

Поиск
Список
Период
Сортировка
От Mainor Alonso Morales González
Тема Change stored procedures schema name
Дата
Msg-id 4A7B3BD9.5060402@ncq.co.cr
обсуждение исходный текст
Ответы Re: Change stored procedures schema name
Re: Change stored procedures schema name
Список pgsql-admin
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 into schema1.table values(pIn,0); --this is just an example :)
    return 0;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE

If I change the schema name using PGADMIN it just change this part:

    CREATE OR REPLACE FUNCTION new_schema.example(double precision) RETURNS numeric AS
    ...........

I'm asking about any way to change the schema of the command inside of the code automatically, because I have many
stored procedure in the database (about 63) and this process could take so much time, I hope had been clear, sorry about
my bad english :S


--
Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: error from postgresql 8.4.0 after a dump/restore from 8.3.5
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Change stored procedures schema name