CREATELANG(1) PostgreSQL Client Applications CREATELANG(1)
NAME createlang - define a new PostgreSQL procedural language
SYNOPSIS createlang [ connection-option... ] langname [ dbname ]
createlang [ connection-option... ] --list | -l dbname
DESCRIPTION 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.
OPTIONS createlang accepts the following command-line arguments:
langname Specifies the name of the procedural programming language to be defined.
[--dbname] 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.
--echo Display SQL commands as they are executed.
--list Show a list of already installed languages in the target database.
createlang also accepts the following command-line arguments for con- nection parameters:
--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.
--port port Specifies the TCP port or local Unix domain socket file exten- sion on which the server is listening for connections.
--username username User name to connect as.
--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.
--password Force createlang to prompt for a password before connecting to a database.
This option is never essential, since createlang will automati- cally 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.
PGUSER Default connection parameters
This utility, like most other PostgreSQL utilities, also uses the envi- ronment variables supported by libpq (see in the documentation).
DIAGNOSTICS Most error messages are self-explanatory. If not, run createlang with the --echo option and see under the respective SQL command for details. Also, any default connection settings and environment variables used by the libpq front-end library will apply.
NOTES Use droplang(1) to remove a language.
EXAMPLES To install the language pltcl into the database template1:
$ createlang pltcl template1
Note that installing the language into template1 will cause it to be automatically installed into subsequently-created databases as well.
SEE ALSO droplang(1), CREATE LANGUAGE [create_language(7)]
Application 2011-01-27 CREATELANG(1)