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

  
 
  

home | help
DROP CONVERSION(7)	  PostgreSQL 18.6 Documentation       DROP CONVERSION(7)

NAME
     DROP_CONVERSION - remove a conversion

SYNOPSIS
     DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]

DESCRIPTION
     DROP CONVERSION removes a previously defined conversion. To be able to drop
     a conversion, you must own the conversion.

PARAMETERS
     IF EXISTS
	 Do not throw an error if the conversion does not exist. A notice is is-
	 sued in this case.

     name
	 The  name  of	the conversion. The conversion name can be schema-quali-
	 fied.

     CASCADE
     RESTRICT
	 These key words do not have any effect, since there are no dependencies
	 on conversions.

EXAMPLES
     To drop the conversion named myname:

	 DROP CONVERSION myname;

COMPATIBILITY
     There is no DROP CONVERSION statement in  the  SQL  standard,  but  a  DROP
     TRANSLATION statement that goes along with the CREATE TRANSLATION statement
     that is similar to the CREATE CONVERSION statement in PostgreSQL.

SEE ALSO
     ALTER  CONVERSION	(ALTER_CONVERSION(7)), CREATE CONVERSION (CREATE_CONVER-
     SION(7))

PostgreSQL 18.6 		      2026		      DROP CONVERSION(7)

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

home | help