DROP LANGUAGE

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.

NoteWarning
 

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';