1DROP CONVERSION(7)      PostgreSQL 9.2.24 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, RESTRICT
25           These key words do not have any effect, since there are no
26           dependencies on conversions.
27

EXAMPLES

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

COMPATIBILITY

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

SEE ALSO

40       ALTER CONVERSION (ALTER_CONVERSION(7)), CREATE CONVERSION
41       (CREATE_CONVERSION(7))
42
43
44
45PostgreSQL 9.2.24                 2017-11-06                DROP CONVERSION(7)