{
    "mode": "man",
    "parameter": "DROP_CONVERSION",
    "section": "7",
    "url": "https://www.chedong.com/phpMan.php/man/DROP_CONVERSION/7/json",
    "generated": "2026-06-16T10:02:35Z",
    "synopsis": "DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]",
    "sections": {
        "NAME": {
            "content": "DROPCONVERSION - remove a conversion\n",
            "subsections": []
        },
        "SYNOPSIS": {
            "content": "DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "DROP CONVERSION removes a previously defined conversion. To be able to drop a conversion, you\nmust own the conversion.\n",
            "subsections": []
        },
        "PARAMETERS": {
            "content": "IF EXISTS\nDo not throw an error if the conversion does not exist. A notice is issued in this case.\n\nname\nThe name of the conversion. The conversion name can be schema-qualified.\n\nCASCADE\nRESTRICT\nThese key words do not have any effect, since there are no dependencies on conversions.\n",
            "subsections": []
        },
        "EXAMPLES": {
            "content": "To drop the conversion named myname:\n\nDROP CONVERSION myname;\n",
            "subsections": []
        },
        "COMPATIBILITY": {
            "content": "There is no DROP CONVERSION statement in the SQL standard, but a DROP TRANSLATION statement\nthat goes along with the CREATE TRANSLATION statement that is similar to the CREATE\nCONVERSION statement in PostgreSQL.\n",
            "subsections": []
        },
        "SEE ALSO": {
            "content": "ALTER CONVERSION (ALTERCONVERSION(7)), CREATE CONVERSION (CREATECONVERSION(7))\n\nPostgreSQL 14.23                               2026                            DROP CONVERSION(7)",
            "subsections": []
        }
    },
    "summary": "DROPCONVERSION - remove a conversion",
    "flags": [],
    "examples": [
        "To drop the conversion named myname:",
        "DROP CONVERSION myname;"
    ],
    "see_also": [
        {
            "name": "ALTERCONVERSION",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/ALTERCONVERSION/7/json"
        },
        {
            "name": "CREATECONVERSION",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/CREATECONVERSION/7/json"
        },
        {
            "name": "CONVERSION",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/CONVERSION/7/json"
        }
    ]
}