This page in other versions: 9.2 / 9.3 / 9.4 / 9.5 / current (9.6)  |  Development versions: devel  |  Unsupported versions: 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0 / 9.1

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.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group