createlang - Add a new programming language to a Postgres
database
SYNOPSIS
createlang [ 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 lan
guage to be defined. createlang will prompt for
langname if it is not specified 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 database (which must be specified).
createlang also accepts the following command line argu
ments for connection 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 directory for the unix domain
socket.
-p, --port port
Specifies the Internet TCP/IP port or local Unix
domain socket file extension on which the postmas
ter is listening for connections.
-U, --username username
Username to connect as.
-W, --password
Force password prompt.
OUTPUTS
Most error messages are self-explanatory. If not, run cre
atelang with the --echo option and see under the respec
tive SQL command for details. Check also under psql(1) for
more possibilities.
createlang is a utility for adding a new programming lan
guage to a Postgres database. createlang currently
accepts several languages, plpgsql, pltcl, pltclu, and
plperl.
Although backend programming languages can be added
directly using several SQL commands, it is recommended to
use createlang because it performs a number of checks and
is much easier to use. See CREATE LANGUAGE [create_lan
guage(l)] for more.
NOTES
Use droplang(1) to remove a language.
USAGE
To install pltcl into the database template1:
$ createlang pltcl template1
Man(1) output converted with
man2html