Man page or keyword search:   man All Sections 1 - General Commands 2 - System Calls 3 - Subroutines, Functions 4 - Special Files 5 - File Formats 6 - Games and Screensavers 7 - Macros and Conventions 8 - Maintenence Commands 9 - Kernel Interface New Commands Server 4.4BSD AIX Alpinelinux Archlinux Aros BSDOS BSDi Bifrost CentOS Cygwin Darwin Debian DigitalUNIX DragonFly ElementaryOS Fedora FreeBSD Gentoo GhostBSD HP-UX Haiku Hurd IRIX Inferno JazzOS Kali Knoppix LinuxMint MacOSX Mageia Mandriva Manjaro Minix MirBSD NeXTSTEP NetBSD OPENSTEP OSF1 OpenBSD OpenDarwin OpenIndiana OpenMandriva OpenServer OpenSuSE OpenVMS Oracle PC-BSD Peanut Pidora Plan9 QNX Raspbian RedHat Scientific Slackware SmartOS Solaris SuSE SunOS Syllable Tru64 UNIXv7 Ubuntu Ultrix UnixWare Xenix YellowDog aLinux   31559 pages apropos Keyword Search (all sections) Output format html ascii pdf view pdf save postscript

DROPLANG(1)	  PostgreSQL Client Applications      DROPLANG(1)

NAME
       droplang - remove a PostgreSQL procedural language

SYNOPSIS
       droplang [ connection-options... ] langname [ dbname ]

       droplang [ connection-options... ]  --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
       PostgreSQL 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(l)]
       for more.

OPTIONS
       droplang accepts the following command line arguments:

       langname
	      Specifies the name of the backend programming  lan-
	      guage 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 Displays SQL commands as they are executed.

       -l

       --list Shows  a list of already installed languages in the
	      target database (which must be specified).

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

       -h host

       --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.

DIAGNOSTICS
       Most error messages  are	 self-explanatory.  If	not,  run
       droplang	 with the --echo option and see under the respec-
       tive SQL command for details. Check also under psql(1) for
       more possibilities.

NOTES
       Use createlang(1) to add a language.

EXAMPLES
       To remove pltcl:

       $ droplang pltcl dbname

SEE ALSO
       createlang(1), DROP LANGUAGE [drop_language(l)]

Application		    2002-11-22		      DROPLANG(1)

Vote for polarhome