Man Linux: Main Page and Category List


       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  CREATE
       LANGUAGE [create_language(7)] command.


       createlang accepts the following command-line arguments:

              Specifies  the name of the procedural programming language to be

       [-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.


       --echo Display SQL commands as they are executed.


       --list Show a  list  of  already  installed  languages  in  the  target

       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.


              Never  issue  a password prompt. If the server requires password
              authentication and a password is not available  by  other  means
              such  as  a .pgpass file, the connection attempt will fail. This
              option can be useful in batch jobs and scripts where no user  is
              present to enter a password.


              Force createlang to prompt for a password before connecting to a

              This  option  is  never   essential,   since   createlang   will
              automatically  prompt  for  a  password  if  the  server demands
              password  authentication.   However,  createlang  will  waste  a
              connection attempt finding out that the server wants a password.
              In some  cases  it  is  worth  typing  -W  to  avoid  the  extra
              connection attempt.





       PGUSER Default connection parameters

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


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


       Use droplang(1) to remove a language.


       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.


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