droplang
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.
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