Penguin
Recent Changes
Annotated edit history of droplang(1) version 1, including all changes. View license author blame.
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 ----
This page is a man page (or other imported legacy content). We are unable to automatically determine the license status of this page.