|The PostgreSQL 9.0 Reference Manual - Volume 1B - SQL Command Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 488 pages
RRP £14.95 ($19.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
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
createlang accepts the following command-line arguments:
- Specifies the name of the procedural programming language to be defined.
- Specifies the database to which the language should be added. The default is to use the database with the same name as the current system user.
- Display SQL commands as they are executed.
- Show a list of already installed languages in the target database.
- Print the createlang version and exit.
- Show help about createlang command line arguments, and exit.
createlang also accepts the following command-line arguments for connection parameters:
- 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.
- Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.
- User name to connect as.
- 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.
Force createlang to prompt for a
password before connecting to a database.
This option is never essential, since
createlang will automatically 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
-Wto avoid the extra connection attempt.
- Default connection parameters
This utility, like most other PostgreSQL utilities, also uses the environment variables supported by libpq (see Volume 2: Environment Variables).
Most error messages are self-explanatory. If not, run
createlang with the
option and see the respective SQL command
for details. Also, any default connection settings and environment
variables used by the libpq front-end
library will apply.
droplang to remove a language.
To install the language
pltcl into the database
$ createlang pltcl template1
Note that installing the language into
will cause it to be automatically installed into subsequently-created
databases as well.
|ISBN 9781906966058||The PostgreSQL 9.0 Reference Manual - Volume 1B - SQL Command Reference||See the print edition|