Tutorials Point


  Unix for Beginners
  Unix Shell Programming
  Advanced Unix
  Unix Useful References
  Unix Useful Resources
  Selected Reading

Copyright © 2014 by tutorialspoint



  Home     References     Discussion Forums     About TP  

createlang - Unix, Linux Command


previous next AddThis Social Bookmark Button


Advertisements

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(7)] command, which see for additional information.

OPTIONS

createlang accepts the following command-line arguments:

TagDescription
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

TagDescription
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(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



previous next Printer Friendly

Advertisements


  

Advertisements