Command Prompt, Inc.
DROP LANGUAGE
Practical PostgreSQL
PrevNext

DROP LANGUAGE

Name

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.

Warning

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
PrevHomeNext
DROP INDEXUpDROP OPERATOR

Powered by Mammoth PostgreSQL
Copyright © 2000-2007 Command Prompt, Inc. All Rights Reserved. All trademarks property of their respective owners.