修改不带参数的存储过程schema

teledb=# CREATE OR REPLACE PROCEDURE public.proc_1() AS
$$
begin
   raise notice 'Hello teledb_pg';
end;
$$
LANGUAGE PLPGSQL;
CREATE PROCEDURE
teledb=# 

teledb=# alter procedure public.proc_1() set schema myche;
ALTER PROCEDURE
teledb=#

修改带参数的存储过程schema

teledb=# CREATE OR REPLACE PROCEDURE public.proc_1(a_int int) AS                       
$$
begin
   raise notice '%',a_int;
end;
$$
LANGUAGE PLPGSQL;
CREATE PROCEDURE

teledb=# alter procedure public.proc_1 (int) set schema myche; 
ALTER PROCEDURE
teledb=#