PostgreSQL 8.1.3 Documentation
Prev	Fast Backward		Fast Forward	Next

createlang

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.

PostgreSQL Manual

createlang

Name

Synopsis

Description

Options

Environment

Diagnostics

Notes

Examples

See Also

Newsletter

Hosted by

Search

Links