CREATELANG(1) PostgreSQL Server Applications CREATELANG(1)NAMEcreatelang - Add a new programming language to a Postgres database
SYNOPSIScreatelang [ connection-options... ] [ langname ] dbname
createlang [ connection-options... ] { --list | -l } dbname
INPUTS
createlang accepts the following command line arguments:
langname
Specifies the name of the backend programming language to be
defined. createlang will prompt for langname if it is not spec‐
ified on the command line.
-d, --dbname dbname
Specifies which database the language should be added.
-l, --list
Shows a list of already installed languages in the target data‐
base (which must be specified).
createlang also accepts the following command line arguments for con‐
nection parameters:
-h, --host host
Specifies the hostname of the machine on which the postmaster is
running. If host begins with a slash, it is used as the direc‐
tory for the unix domain socket.
-p, --port port
Specifies the Internet TCP/IP port or local Unix domain socket
file extension on which the postmaster is listening for connec‐
tions.
-U, --username username
Username to connect as.
-W, --password
Force password prompt.
OUTPUTS
Most error messages are self-explanatory. If not, run createlang with
the --echo option and see under the respective SQL command for details.
Check also under psql(1) for more possibilities.
DESCRIPTIONcreatelang is a utility for adding a new programming language to a
Postgres database. createlang currently accepts several languages,
plpgsql, pltcl, pltclu, and plperl.
Although backend programming languages can be added directly using sev‐
eral SQL commands, it is recommended to use createlang because it per‐
forms a number of checks and is much easier to use. See CREATE LANGUAGE
[create_language(l)] for more.
NOTES
Use droplang(1) to remove a language.
USAGE
To install pltcl into the database template1:
$ createlang pltcl template1
Application 2000-11-11 CREATELANG(1)