.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $.TH "CREATELANG" "1" "2008-01-03" "Application" "PostgreSQL Client Applications".SH NAMEcreatelang \- define a new PostgreSQL procedural language.SH SYNOPSIS.sp\fBcreatelang\fR [ \fB\fIconnection-option\fB\fR\fI...\fR ]  \fB\fIlangname\fB\fR [ \fB\fIdbname\fB\fR ] \fBcreatelang\fR [ \fB\fIconnection-option\fB\fR\fI...\fR ]  \fB [ --list ]  [ -l ] \fR \fB\fIdbname\fB\fR.SH "DESCRIPTION".PP\fBcreatelang\fR is a utility for adding a new programming language to a PostgreSQL database.\fBcreatelang\fR is just a wrapper around theCREATE LANGUAGE [\fBcreate_language\fR(7)]command..SH "OPTIONS".PP\fBcreatelang\fR accepts the following command-line arguments:.TP\fB\fIlangname\fB\fRSpecifies the name of the procedural programming language to bedefined..TP\fB[-d] \fIdbname\fB\fR.TP\fB[--dbname] \fIdbname\fB\fRSpecifies to which database the language should be added.The default is to use the database with the same name as thecurrent system user..TP\fB-e\fR.TP\fB--echo\fRDisplay SQL commands as they are executed..TP\fB-l\fR.TP\fB--list\fRShow a list of already installed languages in the target database..PP.PP\fBcreatelang\fR also accepts the following command-line arguments for connection parameters:.TP\fB-h \fIhost\fB\fR.TP\fB--host \fIhost\fB\fRSpecifies the host name of the machine on which the serveris running. If the value begins with a slash, it is used as the directory for the Unix domain socket..TP\fB-p \fIport\fB\fR.TP\fB--port \fIport\fB\fRSpecifies the TCP port or local Unix domain socket file extension on which the serveris listening for connections..TP\fB-U \fIusername\fB\fR.TP\fB--username \fIusername\fB\fRUser name to connect as..TP\fB-W\fR.TP\fB--password\fRForce password prompt..PP.SH "ENVIRONMENT".TP\fBPGDATABASE\fR.TP\fBPGHOST\fR.TP\fBPGPORT\fR.TP\fBPGUSER\fRDefault connection parameters.PPThis utility, like most other PostgreSQL utilities,also uses the environment variables supported by \fBlibpq\fR(see in the documentation)..PP.SH "DIAGNOSTICS".PPMost error messages are self-explanatory. If not, run\fBcreatelang\fR with the \fB--echo\fRoption and see under the respective SQL commandfor details. Also, any default connection settings and environmentvariables used by the \fBlibpq\fR front-endlibrary will apply..SH "NOTES".PPUse \fBdroplang\fR(1) to remove a language..SH "EXAMPLES".PPTo install the language pltcl into the databasetemplate1:.sp.nf$ \fBcreatelang pltcl template1\fR.sp.fiNote that installing the language into template1will cause it to be automatically installed into subsequently-createddatabases as well..SH "SEE ALSO"\fBdroplang\fR(1), CREATE LANGUAGE [\fBcreate_language\fR(7)]