Defines a new procedural language for a database.
createlang [<connection_option> ...] [-e] <langname> [[-d] <dbname>] createlang [<connection-option> ...] -l <dbname> createlang --help createlang --version
createlang utility adds a new programming language to a database.
createlang is a wrapper around the
SQL command CREATE EXTENSION.
createlang is deprecated and may be removed in a future release. Direct use of the
CREATE EXTENSION command is recommended instead.
The procedural language packages included in the standard Greenplum Database distribution are:
PL/pgSQL language is registered in all databases by default.
Greenplum Database also has language handlers for
PL/R, but those languages are not pre-installed with Greenplum Database. See the Procedural Languages section in the PostgreSQL documentation for more information.
PGDATABASEenvironment variable setting, or the same name as the current system user.
createlanggenerates and sends to the server.
PGHOSTor defaults to localhost.
PGPORTor defaults to
PGUSERor defaults to the current system role name.
.pgpassfile, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to enter a password.
To install the language
plperl into the database
createlang plperl mytestdb