DROP PROCEDURE
Drops a procedure. To drop a procedure, both the procedure name and input argument data types (signature), are required. Optionally, you can include the full argument data types, including OUT arguments. To find the signature for a procedure, use the SHOW PROCEDURE command. For more information about procedure signatures, see PG_PROC_INFO.
Required privileges
Following are required privileges for DROP PROCEDURE:
-
Superuser
-
Users with the DROP PROCEDURE privilege
-
Procedure owner
Syntax
DROP PROCEDURE sp_name ( [ [ argname ] [ argmode ] argtype [, ...] ] )
Parameters
- sp_name
-
The name of the procedure to be removed.
- argname
-
The name of an input argument. DROP PROCEDURE ignores argument names, because only the argument data types are needed to determine the procedure's identity.
- argmode
-
The mode of an argument, which can be IN, OUT, or INOUT. OUT arguments are optional because they aren't used to identify a stored procedure.
- argtype
-
The data type of the input argument. For a list of the supported data types, see Data types.
Examples
The following example drops a stored procedure named
quarterly_revenue.
DROP PROCEDURE quarterly_revenue(volume INOUT bigint, at_price IN numeric,result OUT int);