Penguin
Recent Changes
Blame: createlang(1)
EditPageHistoryDiffInfoLikePages
Annotated edit history of createlang(1) version 1, including all changes. View license author blame.
Rev Author # Line
1 perry 1 CREATELANG
2 !!!CREATELANG
3 NAME
4 SYNOPSIS
5 DESCRIPTION
6 NOTES
7 USAGE
8 ----
9 !!NAME
10
11
12 createlang - define a new PostgreSQL procedural language
13 !!SYNOPSIS
14
15
16 __createlang__ [[ ''connection-options''... ]
17 ''langname'' [[ ''dbname'' ]
18
19
20 __createlang__ [[ ''connection-options''... ]
21 __--list__ | __-l__ ''dbname''
22
23
24 __INPUTS__
25
26
27 __createlang__ accepts the following command line
28 arguments:
29
30
31 ''langname''
32
33
34 Specifies the name of the procedural programming language to
35 be defined.
36
37
38 __-d, --dbname__ ''dbname''
39
40
41 Specifies to which database the language should be added.
42 The default is to use the database with the same name as the
43 current system user.
44
45
46 __-e, --echo__
47
48
49 Displays SQL commands as they are executed.
50
51
52 __-l, --list__
53
54
55 Shows a list of already installed languages in the target
56 database (which must be specified).
57
58
59 __--L__ ''directory''
60
61
62 Specifies the directory in which the language interpreter is
63 to be found. The directory is normally found automatically;
64 this option is primarily for debugging
65 purposes.
66
67
68 __createlang__ also accepts the following command line
69 arguments for connection parameters:
70
71
72 __-h, --host__ ''host''
73
74
75 Specifies the host name of the machine on which the server
76 is running. If host begins with a slash, it is used as the
77 directory for the Unix domain socket.
78
79
80 __-p, --port__ ''port''
81
82
83 Specifies the Internet TCP/IP port or local Unix domain
84 socket file extension on which the server is listening for
85 connections.
86
87
88 __-U, --username__ ''username''
89
90
91 User name to connect as
92
93
94 __-W, --password__
95
96
97 Force password prompt.
98
99
100 __OUTPUTS__
101
102
103 Most error messages are self-explanatory. If not, run
104 __createlang__ with the __--echo__ option and see
105 under the respective SQL command for details. Check also
106 under psql(1) for more possibilities.
107 !!DESCRIPTION
108
109
110 __createlang__ is a utility for adding a new programming
111 language to a PostgreSQL database. __createlang__ can
112 handle all the languages supplied in the default PostgreSQL
113 distribution, but not languages provided by other
114 parties.
115
116
117 Although backend programming languages can be added directly
118 using several SQL commands, it is recommended to use
119 __createlang__ because it performs a number of checks and
120 is much easier to use. See CREATE LANGUAGE
121 [[__create_language__(l)] for more.
122 !!NOTES
123
124
125 Use droplang(1) to remove a language.
126
127
128 __createlang__ is a shell script that invokes __psql__
129 several times. If you have things arranged so that a
130 password prompt is required to connect, you will be prompted
131 for a password several times.
132 !!USAGE
133
134
135 To install pltcl into the database template1:
136
137
138 $ __createlang pltcl template1
139 __
140 ----
This page is a man page (or other imported legacy content). We are unable to automatically determine the license status of this page.