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
command, which see for additional information.
Options
createlang accepts the following command-line arguments:
langname Specifies the name of the procedural programming language to be
defined.
-
[-d] dbname
[--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.
-
-e
--echo
Display SQL commands as they are executed.
-
-l
--list
Show a list of already installed languages in the target database.
createlang also accepts
the following command-line arguments for connection parameters:
-
-h host
--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.
-
-p port
--port port
Specifies the TCP port or local Unix domain socket file
extension on which the server
is listening for connections.
-
-U username
--username username
User name to connect as.
-
-W
--password
Force password prompt.
Environment
-
PGDATABASE
PGHOST
PGPORT
PGUSER
Default connection parameters
Diagnostics
Most error messages are self-explanatory. If not, run
createlang with the --echo
option and see under the respective SQL command
for details.
Notes
Use droplang 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.
