PostgreSQL 7.3.5 Documentation
PrevNext

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

PrevHomeNext
DROP CASTUpDROP DATABASE