修改不带参数的存储过程名称

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

teledb=# alter procedure proc_1() rename to proc_1_1;
ALTER PROCEDURE
teledb=#

修改带参数的存储过程名称

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

teledb=# alter procedure proc_1 (a_int int) rename to proc_1_1;
ALTER PROCEDURE