PostgreSQL 7.3.4 Documentation
Prev |  | Next

# DROP CONVERSION

## Name

DROP CONVERSION -- remove a user-defined conversion

## Synopsis

    DROP CONVERSION conversion_name
        [ CASCADE | RESTRICT ]

## Description

`DROP CONVERSION` removes a previously defined conversion.

To be able to drop a conversion, you must own the conversion.

Parameters

conversion_name

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

CASCADE
RESTRICT

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

## Notes

Use `CREATE CONVERSION` to create user-defined conversions.

The privileges required to drop a conversion may be changed in a future release.

## Examples

To drop the conversion named myname:

    DROP CONVERSION myname;

## Compatibility

`DROP CONVERSION` is a PostgreSQL extension. There is no `DROP CONVERSION` statement in SQL99.

## See Also

CREATE CONVERSION

Prev | Home | Next
DROP CAST | Up | DROP DATABASE