droplang  --  Removes the definition of a procedural language from a database.


droplang [ connection options ] [ langname [ dbname ] ]
droplang [ connection options ] --list|-l


droplang accepts the following command line arguments:


This parameter specifies the name of the backend programming language you are removing. This parameter is required; you will be prompted to enter the name of a language if you do not do so at the command line.

[-d, --dbname] dbname

This parameter specifies which database you wish to remove the target language from. This is required information for the language to be removed.

-l, --list

Passing this option will print a list of languages that are already defined within a specified database.

-h, --host host

If the database server is running on a remote machine, you can use this host to specify the hostname of the server.

-p, --port port

With this parameter, you can specify either the TCP/IP port or local socket file extension that postmaster is listening for connections on.

-U, --username username

Use this parameter to specify a username to connect as.

-W, --password

Passing this parameter will force droplang to prompt you for a password before accessing the database.



This message is displayed if the language was dropped correctly.

droplang: '[language name]' is not installed in database testdb

This error means that the language name is not installed properly within the database.

droplang: droplang: unsupported language 'plc'

This message is displayed if you attempt to drop a language that does not exist.


Use droplang as you would use the SQL DROP LANGUAGE command: to remove a specified language from a database. In its most current incarnation, droplang only accepts plsql and pltcl as parameters. For more information on dropping languages, examine DROP LANGUAGE


This example demonstrates how to remove the pltcl language.

$ droplang pltcl