Name
DROP LANGUAGE
-- Removes the definition of a procedural language.
Synopsis
DROP [PROCEDURAL] LANGUAGE 'name'
Parameters
- name
The sole parameter of this command is the name of the existing procedural language you wish to remove from the database.
Results
- DROP
This message is displayed if the language is removed without error.
- ERROR: Language "name" doesn't exist
This error is displayed if the language you specified does not exist within the database.
Description
Use the DROP PROCEDURAL LANGUAGE command to remove the definition
of the procedural language specified by name.
| Warning |
---|
| This command does not check to make sure that functions and triggers you have registered for
use with this language have been removed; if there are any that you have not been removed (or
if you choose to keep them), change the prolang attribute of the functions
to reflect the new object ID of the pg_language entry for the procedural language.
|
Examples
This example removes the PLsample language.
DROP PROCEDURAL LANGUAGE 'plsample';