
	Download · Mirrors · Lists · Users · Developers · Docs · Search

PostgreSQL 7.3 Documentation
Prev		Next

DROP CONVERSION

Name

DROP CONVERSION -- remove a user-defined conversion

DROP CONVERSION conversion_name
     [ CASCADE | RESTRICT ]

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.

Use CREATE CONVERSION to create user-defined conversions.

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

To drop the conversion named myname:

DROP CONVERSION myname;

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