{
    "content": [
        {
            "type": "text",
            "text": "# DROP_CONVERSION (man)\n\n## NAME\n\nDROPCONVERSION - remove a conversion\n\n## SYNOPSIS\n\nDROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]\n\n## DESCRIPTION\n\nDROP CONVERSION removes a previously defined conversion. To be able to drop a conversion, you\nmust own the conversion.\n\n## Sections\n\n- **NAME**\n- **SYNOPSIS**\n- **DESCRIPTION**\n- **PARAMETERS**\n- **EXAMPLES**\n- **COMPATIBILITY**\n- **SEE ALSO**\n\nUse structuredContent.sections for detailed options, examples, and full documentation.\n"
        }
    ],
    "structuredContent": {
        "command": "DROP_CONVERSION",
        "section": "",
        "mode": "man",
        "summary": "DROPCONVERSION - remove a conversion",
        "synopsis": "DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]",
        "tldr_summary": null,
        "tldr_examples": [],
        "tldr_source": null,
        "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"
            }
        ],
        "section_outline": [
            {
                "name": "NAME",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SYNOPSIS",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "DESCRIPTION",
                "lines": 3,
                "subsections": []
            },
            {
                "name": "PARAMETERS",
                "lines": 10,
                "subsections": []
            },
            {
                "name": "EXAMPLES",
                "lines": 4,
                "subsections": []
            },
            {
                "name": "COMPATIBILITY",
                "lines": 4,
                "subsections": []
            },
            {
                "name": "SEE ALSO",
                "lines": 5,
                "subsections": []
            }
        ],
        "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\n\n\nPostgreSQL 14.23                                2026                              DROP CONVERSION(7)",
                "subsections": []
            }
        }
    }
}