1DROPLANG(1) PostgreSQL 9.2.24 Documentation DROPLANG(1)
2
3
4
6 droplang - remove a PostgreSQL procedural language
7
9 droplang [connection-option...] langname [dbname]
10
11 droplang [connection-option...] --list | -l [dbname]
12
14 droplang is a utility for removing an existing procedural language from
15 a PostgreSQL database.
16
17 droplang is just a wrapper around the DROP EXTENSION
18 (DROP_EXTENSION(7)) SQL command.
19
20 Caution
21 droplang is deprecated and may be removed in a future PostgreSQL
22 release. Direct use of the DROP EXTENSION command is recommended
23 instead.
24
26 droplang accepts the following command line arguments:
27
28 langname
29 Specifies the name of the procedural language to be removed. (This
30 name is lower-cased.)
31
32 [-d] dbname, [--dbname=]dbname
33 Specifies from which database the language should be removed. The
34 default is to use the database with the same name as the current
35 system user.
36
37 -e, --echo
38 Display SQL commands as they are executed.
39
40 -l, --list
41 Show a list of already installed languages in the target database.
42
43 -V, --version
44 Print the droplang version and exit.
45
46 -?, --help
47 Show help about droplang command line arguments, and exit.
48
49 droplang also accepts the following command line arguments for
50 connection parameters:
51
52 -h host, --host=host
53 Specifies the host name of the machine on which the server is
54 running. If host begins with a slash, it is used as the directory
55 for the Unix domain socket.
56
57 -p port, --port=port
58 Specifies the Internet TCP/IP port or local Unix domain socket file
59 extension on which the server is listening for connections.
60
61 -U username, --username=username
62 User name to connect as.
63
64 -w, --no-password
65 Never issue a password prompt. If the server requires password
66 authentication and a password is not available by other means such
67 as a .pgpass file, the connection attempt will fail. This option
68 can be useful in batch jobs and scripts where no user is present to
69 enter a password.
70
71 -W, --password
72 Force droplang to prompt for a password before connecting to a
73 database.
74
75 This option is never essential, since droplang will automatically
76 prompt for a password if the server demands password
77 authentication. However, droplang will waste a connection attempt
78 finding out that the server wants a password. In some cases it is
79 worth typing -W to avoid the extra connection attempt.
80
82 PGDATABASE, PGHOST, PGPORT, PGUSER
83 Default connection parameters
84
85 This utility, like most other PostgreSQL utilities, also uses the
86 environment variables supported by libpq (see Section 31.14,
87 “Environment Variables”, in the documentation).
88
90 Most error messages are self-explanatory. If not, run droplang with the
91 --echo option and see under the respective SQL command for details.
92 Also, any default connection settings and environment variables used by
93 the libpq front-end library will apply.
94
96 Use createlang(1) to add a language.
97
99 To remove the language pltcl:
100
101 $ droplang pltcl dbname
102
104 createlang(1), DROP EXTENSION (DROP_EXTENSION(7)), DROP LANGUAGE
105 (DROP_LANGUAGE(7))
106
107
108
109PostgreSQL 9.2.24 2017-11-06 DROPLANG(1)