1DROP LANGUAGE(7)        PostgreSQL 9.2.24 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).
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)), droplang(1)
49
50
51
52PostgreSQL 9.2.24                 2017-11-06                  DROP LANGUAGE(7)