Removes a procedural language.
droplang [<connection-option> ...] [-e] <langname> [[-d] <dbname>] droplang [<connection-option> ...] [-e] -l <dbname> droplang --help droplang --version
droplang removes an existing programming language from a database.
droplang can drop any procedural language, even those not supplied by the Greenplum Database distribution.
Although programming languages can be removed directly using several SQL commands, it is recommended to use
droplang because it performs a number of checks and is much easier to use.
droplang is a wrapper for the SQL command
PGDATABASEenvironment variable setting, or the same name as the current system user.
droplanggenerates and sends to the server.
PGHOSTor defaults to localhost.
PGPORTor defaults to 5432.
PGUSERor defaults to the current system role name.
.pgpassfile, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to enter a password.
To remove the language
pltcl from the
droplang pltcl mydatabase
DROP LANGUAGE in the Greenplum Database Reference Guide