Unix/Linux Go Back    

RedHat 9 (Linux i386) - man page for createlang (redhat section 1)

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:   man
Select Man Page Set:       apropos Keyword Search (sections above)

CREATELANG(1)			  PostgreSQL Client Applications		    CREATELANG(1)

       createlang - define a new PostgreSQL procedural language

       createlang [ connection-options... ] langname [ dbname ]

       createlang [ connection-options... ]  --list | -l dbname

       createlang  is  a  utility for adding a new programming language to a PostgreSQL database.
       createlang can handle all the languages supplied in the default	PostgreSQL  distribution,
       but not languages provided by other parties.

       Although  backend  programming languages can be added directly using several SQL commands,
       it is recommended to use createlang because it performs a number of  checks  and  is  much
       easier to use. See CREATE LANGUAGE [create_language(7)] for additional information.

       createlang accepts the following command-line arguments:

	      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.


       --echo Displays SQL commands as they are executed.


       --list Shows a list of already installed languages in the target database (which  must  be

       -L directory
	      Specifies  the  directory  in  which  the  language interpreter is to be found. The
	      directory is normally found automatically; this option is primarily  for	debugging

       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 host
	      begins with a slash, it is used as the directory for the Unix domain socket.

       -p port

       --port port
	      Specifies the Internet TCP/IP 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


	      Force password prompt.




       PGUSER Default connection parameters.

       Most  error  messages  are self-explanatory. If not, run createlang with the --echo option
       and see under the respective SQL command for details. Check also under  psql(1)	for  more

       Use droplang(1) to remove a language.

       createlang  is a shell script that invokes psql several times. If you have things arranged
       so that a password prompt is required to connect, you will be prompted for a password sev-
       eral times.

       To install pltcl into the database template1:

       $ createlang pltcl template1

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

Application				    2002-11-22				    CREATELANG(1)
Unix & Linux Commands & Man Pages : ©2000 - 2018 Unix and Linux Forums

All times are GMT -4. The time now is 02:49 AM.