1DROP LANGUAGE(7)         PostgreSQL 12.2 Documentation        DROP LANGUAGE(7)
2
3
4

NAME

6       DROP_LANGUAGE - remove a procedural language
7

SYNOPSIS

9       DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
10

DESCRIPTION

12       DROP LANGUAGE removes the definition of a previously registered
13       procedural language. You must be a superuser or the owner of the
14       language to use DROP LANGUAGE.
15
16           Note
17           As of PostgreSQL 9.1, most procedural languages have been made into
18           “extensions”, and should therefore be removed with DROP EXTENSION
19           (DROP_EXTENSION(7)) not DROP LANGUAGE.
20

PARAMETERS

22       IF EXISTS
23           Do not throw an error if the language does not exist. A notice is
24           issued in this case.
25
26       name
27           The name of an existing procedural language. For backward
28           compatibility, the name can be enclosed by single quotes.
29
30       CASCADE
31           Automatically drop objects that depend on the language (such as
32           functions in the language), and in turn all objects that depend on
33           those objects (see Section 5.14).
34
35       RESTRICT
36           Refuse to drop the language if any objects depend on it. This is
37           the default.
38

EXAMPLES

40       This command removes the procedural language plsample:
41
42           DROP LANGUAGE plsample;
43

COMPATIBILITY

45       There is no DROP LANGUAGE statement in the SQL standard.
46

SEE ALSO

48       ALTER LANGUAGE (ALTER_LANGUAGE(7)), CREATE LANGUAGE
49       (CREATE_LANGUAGE(7))
50
51
52
53PostgreSQL 12.2                      2020                     DROP LANGUAGE(7)