droplang

droplang

Removes a procedural language.

Synopsis

droplang [connection-option ...] [-e] langname [[-d] dbname]

droplang [connection-option ...] [-e] -l dbname

droplang -? | --help

droplang -V | --version

Description

droplang removes an existing procedural language from a database.

droplang is a wrapper for the SQL command DROP EXTENSION.

Note: droplang is deprecated and may be removed in a future release. From Greenplum Database 6.x using droplang to remove a procedural language package generates an error. Use the DROP EXTENSION command instead.

Options

langname
Specifies the name of the procedural language to be removed. (This name is lower-cased.)
[-d] dbname | [--dbname=]dbname
Specifies from which database the language should be removed. The default is to use the PGDATABASE environment variable setting, or the same name as the current system user.
-e | --echo
Echo the commands that droplang generates and sends to the server.
-l | --list
Show a list of already installed languages in the target database.
-V | --version
Print the droplang version and exit.
-? | --help
Show help about droplang command line arguments, and exit.
Connection Options
-h host | --host=host
The host name of the machine on which the Greenplum master database server is running. If not specified, reads from the environment variable PGHOST or defaults to localhost.
-p port | --port=port
The TCP port on which the Greenplum master database server is listening for connections. If not specified, reads from the environment variable PGPORT or defaults to 5432.
-U username | --username=username
The database role name to connect as. If not specified, reads from the environment variable PGUSER or defaults to the current system role name.
-w | --no-password
Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to enter a password.
-W | --password
Force a password prompt.

Examples

To remove the language pltcl from the mydatabase database:

droplang pltcl mydatabase