DROP CONVERSION
remove a conversion
English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- anchor
- SQL-DROPCONVERSION
- file
- sql-dropconversion.html
- lang
- en
- name
- DROP CONVERSION
- purpose
- remove a conversion
- purpose zh
- 移除一个转换
- sections same as
- Unknown
- slug
- 18
- synopsis html
- DROP CONVERSION [ IF EXISTS ] <em class="replaceable"><code>name</code></em> [ CASCADE | RESTRICT ]
- synopsis text
- DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]
Syntax
DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]Syntax diagrams
Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.
Definition PG 18
DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]
Description
DROP CONVERSION removes a previously defined conversion. To be able to drop a conversion, you must own the conversion.
Parameters
IF EXISTSDo not throw an error if the conversion does not exist. A notice is issued in this case.
nameThe name of the conversion. The conversion name can be schema-qualified.
CASCADERESTRICTThese key words do not have any effect, since there are no dependencies on conversions.
Examples
To drop the conversion named myname:
DROP CONVERSION myname;
Compatibility
There is no DROP CONVERSION statement in the SQL standard, but a DROP TRANSLATION statement that goes along with the CREATE TRANSLATION statement that is similar to the CREATE CONVERSION statement in PostgreSQL.
See Also
ALTER CONVERSION, CREATE CONVERSIONCompare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:6896e11d4156a1815337fbf8de66df12ac797250e97f2e3e13cdbd0327bce9c6
Text language: en · wiki-repair-20261023:6896e11d4156a1815337fbf8de66df12ac797250e97f2e3e13cdbd0327bce9c6