|PostgreSQL Reference Manual - Volume 1 - SQL Language Reference|
by The PostgreSQL Global Development Group
Paperback (6"x9"), 716 pages
RRP £32.00 ($49.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
command, q.v. for additional information.
createlang accepts the following command-line arguments:
- Specifies the name of the procedural programming language to be defined.
- 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.
- Display SQL commands as they are executed.
- Show a list of already installed languages in the target database.
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.
- Force password prompt.
- Default connection parameters
Most error messages are self-explanatory. If not, run
createlang with the
option and see under the respective SQL command
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 0954612027||PostgreSQL Reference Manual - Volume 1 - SQL Language Reference||See the print edition|