manpagez: man pages & more
man DROP_CONVERSION(7)
Home | html | info | man
DROP CONVERSION(7)      PostgreSQL 9.4.15 Documentation     DROP CONVERSION(7)




NAME

       DROP_CONVERSION - remove a conversion


SYNOPSIS

       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 EXISTS
           Do not throw an error if the conversion does not exist. A notice is
           issued in this case.

       name
           The name of the conversion. The conversion name can be
           schema-qualified.

       CASCADE
       RESTRICT
           These 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 (ALTER_CONVERSION(7)), CREATE CONVERSION
       (CREATE_CONVERSION(7))



PostgreSQL 9.4.15                    2017                   DROP CONVERSION(7)

PostgreSQL 9.4.15 - Generated Mon Nov 27 19:06:36 CST 2017
© manpagez.com 2000-2025
Individual documents may contain additional copyright information.