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

Description

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

Get Practical PostgreSQL now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.