DROP ROUTINE(7)                   PostgreSQL 12.3 Documentation                   DROP ROUTINE(7)



NAME
       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_AGGREGATE(7)),
       DROP FUNCTION (DROP_FUNCTION(7)), and DROP PROCEDURE (DROP_PROCEDURE(7)) 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
       DROP AGGREGATE (DROP_AGGREGATE(7)), DROP FUNCTION (DROP_FUNCTION(7)), DROP PROCEDURE
       (DROP_PROCEDURE(7)), ALTER ROUTINE (ALTER_ROUTINE(7))

       Note that there is no CREATE ROUTINE command.



PostgreSQL 12.3                                2020                               DROP ROUTINE(7)