- bullseye 13.5-0+deb11u1
|DROP LANGUAGE(7)||PostgreSQL 13.5 Documentation||DROP LANGUAGE(7)|
DROP_LANGUAGE - remove a procedural language
DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
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.
As of PostgreSQL 9.1, most procedural languages have been made into “extensions”, and should therefore be removed with DROP EXTENSION (DROP_EXTENSION(7)) not DROP LANGUAGE.
This command removes the procedural language plsample:
DROP LANGUAGE plsample;
There is no DROP LANGUAGE statement in the SQL standard.