DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

createlang(1)




CREATELANG(1)    PostgreSQL Client Applications     CREATELANG(1)


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 [create_language(5)] com-
     mand.


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  tar-
          get 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

Application          Last change: 2008-01-03                    1

CREATELANG(1)    PostgreSQL Client Applications     CREATELANG(1)

     --port port
          Specifies the TCP port or local Unix domain socket file
          extension  on which the server is listening for connec-
          tions.

     -U username

     --username username
          User name to connect as.

     -W

     --password
          Force password prompt.


ENVIRONMENT

     PGDATABASE

     PGHOST

     PGPORT

     PGUSER
          Default connection parameters

     This utility, like most  other  PostgreSQL  utilities,  also
     uses  the  environment  variables supported by libpq (see in
     the documentation).


DIAGNOSTICS

     Most  error  messages  are  self-explanatory.  If  not,  run
     createlang  with the --echo option and see under the respec-
     tive SQL command for details. Also, any  default  connection
     settings  and environment variables used by the libpq front-
     end library will apply.


NOTES

     Use droplang(1) 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.


SEE ALSO

     droplang(1), CREATE LANGUAGE [create_language(5)]

Application          Last change: 2008-01-03                    2


Man(1) output converted with man2html