1DROP LANGUAGE(7)         PostgreSQL 15.4 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           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.
28
29       CASCADE
30           Automatically drop objects that depend on the language (such as
31           functions in the language), and in turn all objects that depend on
32           those objects (see Section 5.14).
33
34       RESTRICT
35           Refuse to drop the language if any objects depend on it. This is
36           the default.
37

EXAMPLES

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

COMPATIBILITY

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

SEE ALSO

47       ALTER LANGUAGE (ALTER_LANGUAGE(7)), CREATE LANGUAGE
48       (CREATE_LANGUAGE(7))
49
50
51
52PostgreSQL 15.4                      2023                     DROP LANGUAGE(7)