This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
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.