1DROP CONVERSION(7) PostgreSQL 14.3 Documentation DROP CONVERSION(7)
2
3
4
6 DROP_CONVERSION - remove a conversion
7
9 DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]
10
12 DROP CONVERSION removes a previously defined conversion. To be able to
13 drop a conversion, you must own the conversion.
14
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
30 To drop the conversion named myname:
31
32 DROP CONVERSION myname;
33
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
41 ALTER CONVERSION (ALTER_CONVERSION(7)), CREATE CONVERSION
42 (CREATE_CONVERSION(7))
43
44
45
46PostgreSQL 14.3 2022 DROP CONVERSION(7)