version 1, including all changes.
.
Rev |
Author |
# |
Line |
1 |
perry |
1 |
DROPLANG |
|
|
2 |
!!!DROPLANG |
|
|
3 |
NAME |
|
|
4 |
SYNOPSIS |
|
|
5 |
DESCRIPTION |
|
|
6 |
NOTES |
|
|
7 |
USAGE |
|
|
8 |
---- |
|
|
9 |
!!NAME |
|
|
10 |
|
|
|
11 |
|
|
|
12 |
droplang - remove a PostgreSQL procedural language |
|
|
13 |
!!SYNOPSIS |
|
|
14 |
|
|
|
15 |
|
|
|
16 |
__droplang__ [[ ''connection-options''... ] |
|
|
17 |
''langname'' [[ ''dbname'' ] |
|
|
18 |
|
|
|
19 |
|
|
|
20 |
__droplang__ [[ ''connection-options''... ] |
|
|
21 |
__--list__ | __-l__ ''dbname'' |
|
|
22 |
|
|
|
23 |
|
|
|
24 |
__INPUTS__ |
|
|
25 |
|
|
|
26 |
|
|
|
27 |
__droplang__ accepts the following command line |
|
|
28 |
arguments: |
|
|
29 |
|
|
|
30 |
|
|
|
31 |
''langname'' |
|
|
32 |
|
|
|
33 |
|
|
|
34 |
Specifies the name of the backend programming language to be |
|
|
35 |
removed. |
|
|
36 |
|
|
|
37 |
|
|
|
38 |
__[[-d, --dbname]__ ''dbname'' |
|
|
39 |
|
|
|
40 |
|
|
|
41 |
Specifies from which database the language should be |
|
|
42 |
removed. The default is to use the database with the same |
|
|
43 |
name as the 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 |
__droplang__ also accepts the following command line |
|
|
60 |
arguments for connection parameters: |
|
|
61 |
|
|
|
62 |
|
|
|
63 |
__-h, --host__ ''host'' |
|
|
64 |
|
|
|
65 |
|
|
|
66 |
Specifies the host name of the machine on which the server |
|
|
67 |
is running. If host begins with a slash, it is used as the |
|
|
68 |
directory for the Unix domain socket. |
|
|
69 |
|
|
|
70 |
|
|
|
71 |
__-p, --port__ ''port'' |
|
|
72 |
|
|
|
73 |
|
|
|
74 |
Specifies the Internet TCP/IP port or local Unix domain |
|
|
75 |
socket file extension on which the server is listening for |
|
|
76 |
connections. |
|
|
77 |
|
|
|
78 |
|
|
|
79 |
__-U, --username__ ''username'' |
|
|
80 |
|
|
|
81 |
|
|
|
82 |
User name to connect as |
|
|
83 |
|
|
|
84 |
|
|
|
85 |
__-W, --password__ |
|
|
86 |
|
|
|
87 |
|
|
|
88 |
Force password prompt. |
|
|
89 |
|
|
|
90 |
|
|
|
91 |
__OUTPUTS__ |
|
|
92 |
|
|
|
93 |
|
|
|
94 |
Most error messages are self-explanatory. If not, run |
|
|
95 |
__droplang__ with the __--echo__ option and see under |
|
|
96 |
the respective SQL command for details. Check also under |
|
|
97 |
psql(1) for more possibilities. |
|
|
98 |
!!DESCRIPTION |
|
|
99 |
|
|
|
100 |
|
|
|
101 |
__droplang__ is a utility for removing an existing |
|
|
102 |
programming language from a PostgreSQL database. |
|
|
103 |
__droplang__ can drop any procedural language, even those |
|
|
104 |
not supplied by the PostgreSQL distribution. |
|
|
105 |
|
|
|
106 |
|
|
|
107 |
Although backend programming languages can be removed |
|
|
108 |
directly using several SQL commands, it is recommended to |
|
|
109 |
use __droplang__ because it performs a number of checks |
|
|
110 |
and is much easier to use. See DROP LANGUAGE |
|
|
111 |
[[__drop_language__(l)] for more. |
|
|
112 |
!!NOTES |
|
|
113 |
|
|
|
114 |
|
|
|
115 |
Use createlang(1) to add a language. |
|
|
116 |
!!USAGE |
|
|
117 |
|
|
|
118 |
|
|
|
119 |
To remove pltcl: |
|
|
120 |
|
|
|
121 |
|
|
|
122 |
$ __droplang pltcl dbname |
|
|
123 |
__ |
|
|
124 |
---- |