Postgresql 中文操作指南
Description
DROP LANGUAGE 删除以前注册的过程语言的定义。您必须是超级用户或语言所有者才能使用 DROP LANGUAGE 。
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
从 PostgreSQL 9.1 开始，大多数过程语言都变成了“扩展”，因此应该用 DROP EXTENSION 删除它们，而不是 DROP LANGUAGE 。
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 EXISTS
-
Do not throw an error if the language does not exist. A notice is issued in this case.
-
-
name
-
The name of an existing procedural language.
-
-
CASCADE
-
Automatically 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.14).
-
-
RESTRICT
-
Refuse to drop the language if any objects depend on it. This is the default.
-
Examples
此命令将移除程序语言 plsample ：
This command removes the procedural language plsample:
DROP LANGUAGE plsample;