Postgres Pro Standard : Documentation: 9.6: droplang : Postgres Professional

droplang
Prev	Up	II. Postgres Pro Client Applications	Home	Next

droplang

droplang — remove a Postgres Pro procedural language

Synopsis

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

droplang [connection-option...] --list | -l [dbname]

Description

droplang is a utility for removing an existing procedural language from a Postgres Pro database.

droplang is just a wrapper around the DROP EXTENSION SQL command.

Caution

droplang is deprecated and may be removed in a future Postgres Pro release. Direct use of the DROP EXTENSION command is recommended instead.

Options

droplang accepts the following command line arguments:

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 database with the same name as the current system user.
-e --echo: Display SQL commands as they are executed.
-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.

droplang also accepts the following command line arguments for connection parameters:

-h host --host=host

Specifies the host name of the machine on which the server is running. If host begins with a slash, it is used as the directory for the Unix domain socket.

-p port --port=port

Specifies the Internet TCP/IP port or local Unix domain socket file extension on which the server is listening for connections.

-U username --username=username

User name to connect as.

-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 droplang to prompt for a password before connecting to a database.

This option is never essential, since droplang will automatically prompt for a password if the server demands password authentication. However, droplang will waste a connection attempt finding out that the server wants a password. In some cases it is worth typing -W to avoid the extra connection attempt.

Environment

PGDATABASE PGHOST PGPORT PGUSER: Default connection parameters

This utility, like most other Postgres Pro utilities, also uses the environment variables supported by libpq (see Section 30.14).

Diagnostics

Most error messages are self-explanatory. If not, run droplang with the --echo option and see under the respective SQL command for details. Also, any default connection settings and environment variables used by the libpq front-end library will apply.

Notes

Use createlang to add a language.

Examples

To remove the language pltcl:

$ droplang pltcl dbname