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

FreeBSD Manual Pages

  
 
  

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

NAME
       DROP_TRANSFORM -	remove a transform

SYNOPSIS
       DROP TRANSFORM [	IF EXISTS ] FOR	type_name LANGUAGE lang_name [ CASCADE | RESTRICT ]

DESCRIPTION
       DROP TRANSFORM removes a	previously defined transform.

       To be able to drop a transform, you must	own the	type and the language.
       These are the same privileges that are required to create a transform.

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

       type_name
	   The name of the data	type of	the transform.

       lang_name
	   The name of the language of the transform.

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

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

EXAMPLES
       To drop the transform for type hstore and language plpython3u:

	   DROP	TRANSFORM FOR hstore LANGUAGE plpython3u;

COMPATIBILITY
       This form of DROP TRANSFORM is a	PostgreSQL extension. See CREATE
       TRANSFORM (CREATE_TRANSFORM(7)) for details.

SEE ALSO
       CREATE TRANSFORM	(CREATE_TRANSFORM(7))

PostgreSQL 17.5			     2025		     DROP TRANSFORM(7)

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

home | help