Practical PostgreSQL

Drop Language

Removes a procedural language from a database.

Synopsis

DROP [ PROCEDURAL ] LANGUAGE 'name'

Parameters

name

The name of the existing language you wish to remove from the database.

Results

DROP

The message returned if the language is successfully removed without error.

ERROR: Language "name" doesn’t exist

The error returned if the language you specify does not exist within the database.

Description

Use the DROP PROCEDURAL LANGUAGE command to remove the definition of the procedural language named name.

Note

DROP LANGUAGE does not check to make sure that functions and triggers you have registered for use with this language have been removed. Be sure that no existing functions in your database rely on a language before dropping it.

Example

The following example removes the plexample language from the booktown database:

booktown=# DROP PROCEDURAL LANGUAGE 'plexample';
DROP