createlang - define a new PostgreSQL procedural language
createlang [ connection-option... ] langname [ dbname ]
createlang [ connection-option... ] --list | -l dbname
createlang is a utility for adding a new programming language to a PostgreSQL database. createlang is just a wrapper around the CREATE LANGUAGE [create_language(7)] command, which see for additional information.
createlang accepts the following command-line arguments:
langname Specifies the name of the procedural programming language to be defined. [-d] dbname
Specifies to which database the language should be added. The default is to use the database with the same name as the current system user. -e
Display SQL commands as they are executed. -l
Show a list of already installed languages in the target database. createlang also accepts the following command-line arguments for connection parameters: -h 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
Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. -U username
User name to connect as. -W
Force password prompt.
Default connection parameters
Most error messages are self-explanatory. If not, run createlang with the --echo option and see under the respective SQL command for details.
Use droplang(1) to remove a language.
To install the language pltcl into the database template1:
$ createlang pltcl template1Note that installing the language into template1 will cause it to be automatically installed into subsequently-created databases as well.
droplang(1), CREATE LANGUAGE [create_language(7)], Environment Variables (the documentation)