1DROP LANGUAGE(7) PostgreSQL 12.6 Documentation DROP LANGUAGE(7)
2
3
4
6 DROP_LANGUAGE - remove a procedural language
7
9 DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
10
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
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
40 This command removes the procedural language plsample:
41
42 DROP LANGUAGE plsample;
43
45 There is no DROP LANGUAGE statement in the SQL standard.
46
48 ALTER LANGUAGE (ALTER_LANGUAGE(7)), CREATE LANGUAGE
49 (CREATE_LANGUAGE(7))
50
51
52
53PostgreSQL 12.6 2021 DROP LANGUAGE(7)