1DROP CONVERSION(7)       PostgreSQL 14.3 Documentation      DROP CONVERSION(7)
2
3
4

NAME

6       DROP_CONVERSION - remove a conversion
7

SYNOPSIS

9       DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]
10

DESCRIPTION

12       DROP CONVERSION removes a previously defined conversion. To be able to
13       drop a conversion, you must own the conversion.
14

PARAMETERS

16       IF EXISTS
17           Do not throw an error if the conversion does not exist. A notice is
18           issued in this case.
19
20       name
21           The name of the conversion. The conversion name can be
22           schema-qualified.
23
24       CASCADE
25       RESTRICT
26           These key words do not have any effect, since there are no
27           dependencies on conversions.
28

EXAMPLES

30       To drop the conversion named myname:
31
32           DROP CONVERSION myname;
33

COMPATIBILITY

35       There is no DROP CONVERSION statement in the SQL standard, but a DROP
36       TRANSLATION statement that goes along with the CREATE TRANSLATION
37       statement that is similar to the CREATE CONVERSION statement in
38       PostgreSQL.
39

SEE ALSO

41       ALTER CONVERSION (ALTER_CONVERSION(7)), CREATE CONVERSION
42       (CREATE_CONVERSION(7))
43
44
45
46PostgreSQL 14.3                      2022                   DROP CONVERSION(7)