droplang

Name

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

Synopsis

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

Parameters

droplang accepts the following command line arguments:

langname

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.

Results

DROP LANGUAGE

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.

Description

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

Examples

This example demonstrates how to remove the pltcl language.

$ droplang pltcl