DROP LANGUAGE
remove a procedural language
English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- anchor
- SQL-DROPLANGUAGE
- file
- sql-droplanguage.html
- lang
- en
- name
- DROP LANGUAGE
- purpose
- remove a procedural language
- purpose zh
- 移除一种过程语言
- sections same as
- Unknown
- slug
- 18
- synopsis html
- DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] <em class="replaceable"><code>name</code></em> [ CASCADE | RESTRICT ]
- synopsis text
- DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
Syntax
DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]Syntax diagrams
Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.
Definition PG 18
DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
Description
DROP LANGUAGE removes the definition of a previously registered procedural language. You must be a superuser or the owner of the language to use DROP LANGUAGE.
Note
As of PostgreSQL 9.1, most procedural languages have been made into “extensions”, and should therefore be removed with DROP EXTENSION not DROP LANGUAGE.
Parameters
IF EXISTSDo not throw an error if the language does not exist. A notice is issued in this case.
nameThe name of an existing procedural language.
CASCADEAutomatically drop objects that depend on the language (such as functions in the language), and in turn all objects that depend on those objects (see Section 5.15).
RESTRICTRefuse to drop the language if any objects depend on it. This is the default.
Examples
This command removes the procedural language plsample:
DROP LANGUAGE plsample;
Compatibility
There is no DROP LANGUAGE statement in the SQL standard.
See Also
ALTER LANGUAGE, CREATE LANGUAGECompare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:1154c49d75ad8d7190c03106a8b936c7284e080c4746dbef0beda9e1b51a74c9
Text language: en · wiki-repair-20261023:1154c49d75ad8d7190c03106a8b936c7284e080c4746dbef0beda9e1b51a74c9