Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DROP LANGUAGE(7)	 PostgreSQL 17.5 Documentation	      DROP LANGUAGE(7)

NAME
       DROP_LANGUAGE - remove a	procedural language

SYNOPSIS
       DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS	] name [ CASCADE | RESTRICT ]

DESCRIPTION
       DROP LANGUAGE removes the definition of a previously registered
       procedural language. You	must be	a superuser or the owner of the
       language	to use DROP LANGUAGE.

	   Note

	   As of PostgreSQL 9.1, most procedural languages have	been made into
	   "extensions", and should therefore be removed with DROP EXTENSION
	   not DROP LANGUAGE.

PARAMETERS
       IF EXISTS
	   Do not throw	an error if the	language does not exist. A notice is
	   issued in this case.

       name
	   The name of an existing procedural language.

       CASCADE
	   Automatically drop objects that depend on the language (such	as
	   functions in	the language), and in turn all objects that depend on
	   those objects (see Section 5.15).

       RESTRICT
	   Refuse to drop the language if any objects depend on	it. This is
	   the default.

EXAMPLES
       This command removes the	procedural language plsample:

	   DROP	LANGUAGE plsample;

COMPATIBILITY
       There is	no DROP	LANGUAGE statement in the SQL standard.

SEE ALSO
       ALTER LANGUAGE (ALTER_LANGUAGE(7)), CREATE LANGUAGE
       (CREATE_LANGUAGE(7))

PostgreSQL 17.5			     2025		      DROP LANGUAGE(7)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=DROP_LANGUAGE&sektion=7&manpath=FreeBSD+Ports+14.3.quarterly>

home | help