修改不带参数的存储过程所属用户

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

teledb=# alter procedure proc_1() owner to teledb_admin;
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 (int) owner to teledb_admin;
ALTER PROCEDURE
teledb=#