Name

createlang — install a PostgreSQL™ procedural language

Synopsis

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

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

Description

createlang is a utility for adding a procedural language to a PostgreSQL™ database.

createlang is just a wrapper around the CREATE EXTENSION(7) SQL command.

Caution

createlang is deprecated and may be removed in a future PostgreSQL™ release. Direct use of the CREATE EXTENSION command is recommended instead.

Options

createlang accepts the following command-line arguments:

langname

Specifies the name of the procedural language to be installed. (This name is lower-cased.)

[-d] dbname, [--dbname=]dbname

Specifies the database to which the language should be added. 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 createlang version and exit.

-?, --help

Show help about createlang command line arguments, and exit.

createlang 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 the value begins with a slash, it is used as the directory for the Unix domain socket.

-p port, --port=port

Specifies the TCP 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 createlang to prompt for a password before connecting to a database.

This option is never essential, since createlang will automatically prompt for a password if the server demands password authentication. However, createlang 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.

Notes

Use droplang(1) to remove a language.