—
NAME
DROP_LANGUAGE - remove a procedural language
SYNOPSIS
bash
DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] \nname\n [ 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.
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
name
CASCADE
RESTRICT
EXAMPLES
This command removes the procedural language plsample:
bash
DROP LANGUAGE plsample;COMPATIBILITY
There is no DROP LANGUAGE statement in the SQL standard.
SEE ALSO
ALTER LANGUAGE (ALTER_LANGUAGE(7)), CREATE LANGUAGE (CREATE_LANGUAGE(7))