PostgreSQL

PostgreSQL Elephant Logo

DROP ROUTINE

DROP ROUTINE — remove a routine

Synopsis

DROP ROUTINE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...]
    [ CASCADE | RESTRICT ]

Description

DROP ROUTINE removes the definition of an existing routine, which can be an aggregate function, a normal function, or a procedure. See under DROP AGGREGATE, DROP FUNCTION, and DROP PROCEDURE for the description of the parameters, more examples, and further details.

Examples

To drop the routine foo for type integer:

DROP ROUTINE foo(integer);

This command will work independent of whether foo is an aggregate, function, or procedure.

Compatibility

This command conforms to the SQL standard, with these PostgreSQL extensions:

  • The standard only allows one routine to be dropped per command.

  • The IF EXISTS option

  • The ability to specify argument modes and names

  • Aggregate functions are an extension.

See Also

[.refentrytitle#DROP AGGREGATE], DROP FUNCTION, DROP PROCEDURE, ALTER ROUTINE#

Note that there is no CREATE ROUTINE command.

Prev Up Next

DROP ROLE

Home

DROP RULE

Privacy Policy | Code of Conduct | About PostgreSQL | Contact

Copyright © 1996-2023 The PostgreSQL Global Development Group