---
name: "DROP_CONVERSION"
section: "7"
platform: "linux"
package: "postgresql"
version: "18.6-4"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/DROP_CONVERSION"
---

# DROP\_CONVERSION(7)

remove a conversion

## 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)](/ALTER_CONVERSION/7.md)), CREATE CONVERSION ([**CREATE\_CONVERSION**(7)](/CREATE_CONVERSION/7.md))