t
 Title: DROP CONVERSION
 Author: The PostgreSQL Global Development Group
 Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
 Date: 2021
 Manual: PostgreSQL 10.19 Documentation
 Source: PostgreSQL 10.19
 Language: English

 "DROP CONVERSION" "7" "2021" "PostgreSQL 10.19" "PostgreSQL 10.19 Documentation"
 -----------------------------------------------------------------
 * Define some portability stuff
 -----------------------------------------------------------------
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 http://bugs.debian.org/507673
 http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 -----------------------------------------------------------------
 * set default formatting
 -----------------------------------------------------------------
 disable hyphenation
 disable justification (adjust text to left margin only)
 -----------------------------------------------------------------
 * MAIN CONTENT STARTS HERE *
 -----------------------------------------------------------------
 "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 issued in this case.




name


The name of the conversion. The conversion name can be schema-qualified.




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_CONVERSION(7))