DROP PROCEDURE

A DDL command to remove a procedure

DROP PROCEDURE is a DDL command to remove a procedure.

DROP PROCEDURE was added in PostgreSQL 11.

Change history

Examples

postgres=# CREATE PROCEDURE foo(INOUT bar INT) LANGUAGE SQL AS $$SELECT bar + 1;$$;
CREATE PROCEDURE
postgres=# DROP PROCEDURE foo(INT);
DROP PROCEDURE

Categories

DDL, Functions and procedures

See also

DROP ROUTINE, DROP FUNCTION, CREATE PROCEDURE, ALTER PROCEDURE