2 doc/src/sgml/ref/droplang.sgml
3 PostgreSQL documentation
6 <refentry id="APP-DROPLANG">
7 <indexterm zone="app-droplang">
8 <primary>droplang</primary>
12 <refentrytitle><application>droplang</application></refentrytitle>
13 <manvolnum>1</manvolnum>
14 <refmiscinfo>Application</refmiscinfo>
18 <refname>droplang</refname>
19 <refpurpose>remove a <productname>PostgreSQL</productname> procedural language</refpurpose>
24 <command>droplang</command>
25 <arg rep="repeat"><replaceable>connection-option</replaceable></arg>
26 <arg choice="plain"><replaceable>langname</replaceable></arg>
27 <arg choice="opt"><replaceable>dbname</replaceable></arg>
31 <command>droplang</command>
32 <arg rep="repeat"><replaceable>connection-option</replaceable></arg>
33 <group choice="plain"><arg choice="plain"><option>--list</option></arg><arg choice="plain"><option>-l</option></arg></group>
34 <arg choice="opt"><replaceable>dbname</replaceable></arg>
38 <refsect1 id="R1-APP-DROPLANG-1">
44 <application>droplang</application> is a utility for removing an
45 existing procedural language from a
46 <productname>PostgreSQL</productname> database.
50 <application>droplang</application> is just a wrapper around the
51 <xref linkend="sql-dropextension"> SQL command.
56 <application>droplang</application> is deprecated and may be removed
57 in a future <productname>PostgreSQL</productname> release. Direct use
58 of the <command>DROP EXTENSION</> command is recommended instead.
65 <title>Options</title>
68 <application>droplang</application> accepts the following command line arguments:
72 <term><replaceable class="parameter">langname</replaceable></term>
75 Specifies the name of the procedural language to be removed.
76 (This name is lower-cased.)
82 <term><option><optional>-d</> <replaceable class="parameter">dbname</replaceable></></term>
83 <term><option><optional>--dbname=</><replaceable class="parameter">dbname</replaceable></></term>
86 Specifies from which database the language should be removed.
87 The default is to use the database with the same name as the
94 <term><option>-e</></term>
95 <term><option>--echo</></term>
98 Display SQL commands as they are executed.
104 <term><option>-l</></term>
105 <term><option>--list</></term>
108 Show a list of already installed languages in the target database.
114 <term><option>-V</></term>
115 <term><option>--version</></term>
118 Print the <application>droplang</application> version and exit.
124 <term><option>-?</></term>
125 <term><option>--help</></term>
128 Show help about <application>droplang</application> command line
138 <application>droplang</application> also accepts
139 the following command line arguments for connection parameters:
143 <term><option>-h <replaceable class="parameter">host</replaceable></></term>
144 <term><option>--host=<replaceable class="parameter">host</replaceable></></term>
147 Specifies the host name of the machine on which the
149 is running. If host begins with a slash, it is used
150 as the directory for the Unix domain socket.
156 <term><option>-p <replaceable class="parameter">port</replaceable></></term>
157 <term><option>--port=<replaceable class="parameter">port</replaceable></></term>
160 Specifies the Internet TCP/IP port or local Unix domain socket file
161 extension on which the server
162 is listening for connections.
168 <term><option>-U <replaceable class="parameter">username</replaceable></></term>
169 <term><option>--username=<replaceable class="parameter">username</replaceable></></term>
172 User name to connect as.
178 <term><option>-w</></term>
179 <term><option>--no-password</></term>
182 Never issue a password prompt. If the server requires
183 password authentication and a password is not available by
184 other means such as a <filename>.pgpass</filename> file, the
185 connection attempt will fail. This option can be useful in
186 batch jobs and scripts where no user is present to enter a
193 <term><option>-W</></term>
194 <term><option>--password</></term>
197 Force <application>droplang</application> to prompt for a
198 password before connecting to a database.
202 This option is never essential, since
203 <application>droplang</application> will automatically prompt
204 for a password if the server demands password authentication.
205 However, <application>droplang</application> will waste a
206 connection attempt finding out that the server wants a password.
207 In some cases it is worth typing <option>-W</> to avoid the extra
219 <title>Environment</title>
223 <term><envar>PGDATABASE</envar></term>
224 <term><envar>PGHOST</envar></term>
225 <term><envar>PGPORT</envar></term>
226 <term><envar>PGUSER</envar></term>
230 Default connection parameters
237 This utility, like most other <productname>PostgreSQL</> utilities,
238 also uses the environment variables supported by <application>libpq</>
239 (see <xref linkend="libpq-envars">).
246 <title>Diagnostics</title>
249 Most error messages are self-explanatory. If not, run
250 <application>droplang</application> with the <option>--echo</option>
251 option and see under the respective <acronym>SQL</acronym> command
252 for details. Also, any default connection settings and environment
253 variables used by the <application>libpq</application> front-end
263 Use <xref linkend="app-createlang"> to add a language.
269 <title>Examples</title>
272 To remove the language <literal>pltcl</literal>:
274 <prompt>$ </prompt><userinput>droplang pltcl dbname</userinput>
279 <title>See Also</title>
281 <simplelist type="inline">
282 <member><xref linkend="app-createlang"></member>
283 <member><xref linkend="sql-dropextension"></member>
284 <member><xref linkend="sql-droplanguage"></member>