SQL Commands / Types & Operators

DROP CONVERSION

remove a conversion

Reading PG 18current·documented in 25 of 30 versions, 7.3 to 20

6.4 6.5 7.0 7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Syntax

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

Syntax diagrams

Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.

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.

Related entries

CREATE CONVERSION ALTER CONVERSION

Definition snapshot: b7bd9cda · English manual source