删除不带参数的存储过程

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

teledb=# drop procedure proc_1 ( );
DROP PROCEDURE
teledb=#

删除带参数的存储过程

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

teledb=# drop procedure proc_1 ( a_int int);
DROP PROCEDURE
teledb=#

也可以只指定参数的类型即可。

teledb=# drop procedure proc_1 (int);   
DROP PROCEDURE
teledb=#