droplang(1)

DROPLANG(1)      PostgreSQL Client Applications       DROPLANG(1)

NAME

     droplang - remove a PostgreSQL procedural language

SYNOPSIS

     droplang [ connection-option... ]  langname [ dbname ]

     droplang [ connection-option... ]    [  --list  ]   [  -l  ]
     dbname

DESCRIPTION

     droplang is a utility for removing an  existing  programming
     language  from a PostgreSQL database.  droplang can drop any
     procedural language, even those not supplied  by  the  Post-
     greSQL distribution.

     Although  backend  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. See DROP LANGUAGE [drop_language(5)] for
     more.

OPTIONS

     droplang accepts the following command line arguments:

     langname
          Specifies the name of the backend programming  language
          to be removed.

     [-d] dbname

     [--dbname] dbname
          Specifies from which database the  language  should  be
          removed.   The  default is to use the database with the
          same name as the current system user.

     -e

     --echo
          Display SQL commands as they are executed.

     -l

     --list
          Show a list of already installed languages in the  tar-
          get database.

     droplang also accepts the following command  line  arguments
     for connection parameters:

     -h host

Application          Last change: 2008-01-03                    1

DROPLANG(1)      PostgreSQL Client Applications       DROPLANG(1)

     --host host
          Specifies the host name of the  machine  on  which  the
          server  is  running. If host begins with a slash, it is
          used as the directory for the Unix domain socket.

     -p port

     --port port
          Specifies the Internet TCP/IP port or local Unix domain
          socket  file extension on which the server is listening
          for connections.

     -U username

     --username username
          User name to connect as

     -W

     --password
          Force password prompt.

ENVIRONMENT

     PGDATABASE

     PGHOST

     PGPORT

     PGUSER
          Default connection parameters

     This utility, like most  other  PostgreSQL  utilities,  also
     uses  the  environment  variables supported by libpq (see in
     the documentation).

DIAGNOSTICS

     Most error messages are self-explanatory. If not,  run  dro-
     plang  with  the  --echo option and see under the respective
     SQL command for details. Also, any default  connection  set-
     tings  and environment variables used by the libpq front-end
     library will apply.

NOTES

     Use createlang(1) to add a language.

EXAMPLES

     To remove the language pltcl:

     $ droplang pltcl dbname

Application          Last change: 2008-01-03                    2

DROPLANG(1)      PostgreSQL Client Applications       DROPLANG(1)

SEE ALSO

     createlang(1), DROP LANGUAGE [drop_language(5)]

Application          Last change: 2008-01-03                    3