DROP CONVERSION
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 EXISTSDo not throw an error if the conversion does not exist. A notice is issued in this case.
nameThe name of the conversion. The conversion name can be schema-qualified.
CASCADERESTRICTThese key words do not have any effect, since there are no dependencies on conversions.
Examples
To drop the conversion namedmyname:
DROP CONVERSION myname;
Compatibility
There is noDROP CONVERSION statement in the SQL standard, but aDROP TRANSLATION statement that goes along with theCREATE TRANSLATION statement that is similar to theCREATE CONVERSION statement in Postgres Pro.