{
    "content": [
        {
            "type": "text",
            "text": "# DROP_TRANSFORM (man)\n\n## NAME\n\nDROPTRANSFORM - remove a transform\n\n## SYNOPSIS\n\nDROP TRANSFORM [ IF EXISTS ] FOR typename LANGUAGE langname [ CASCADE | RESTRICT ]\n\n## DESCRIPTION\n\nDROP TRANSFORM removes a previously defined transform.\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_TRANSFORM",
        "section": "",
        "mode": "man",
        "summary": "DROPTRANSFORM - remove a transform",
        "synopsis": "DROP TRANSFORM [ IF EXISTS ] FOR typename LANGUAGE langname [ CASCADE | RESTRICT ]",
        "tldr_summary": null,
        "tldr_examples": [],
        "tldr_source": null,
        "flags": [],
        "examples": [
            "To drop the transform for type hstore and language plpythonu:",
            "DROP TRANSFORM FOR hstore LANGUAGE plpythonu;"
        ],
        "see_also": [
            {
                "name": "CREATETRANSFORM",
                "section": "7",
                "url": "https://www.chedong.com/phpMan.php/man/CREATETRANSFORM/7/json"
            },
            {
                "name": "TRANSFORM",
                "section": "7",
                "url": "https://www.chedong.com/phpMan.php/man/TRANSFORM/7/json"
            }
        ],
        "section_outline": [
            {
                "name": "NAME",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SYNOPSIS",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "DESCRIPTION",
                "lines": 5,
                "subsections": []
            },
            {
                "name": "PARAMETERS",
                "lines": 16,
                "subsections": []
            },
            {
                "name": "EXAMPLES",
                "lines": 4,
                "subsections": []
            },
            {
                "name": "COMPATIBILITY",
                "lines": 3,
                "subsections": []
            },
            {
                "name": "SEE ALSO",
                "lines": 5,
                "subsections": []
            }
        ],
        "sections": {
            "NAME": {
                "content": "DROPTRANSFORM - remove a transform\n",
                "subsections": []
            },
            "SYNOPSIS": {
                "content": "DROP TRANSFORM [ IF EXISTS ] FOR typename LANGUAGE langname [ CASCADE | RESTRICT ]\n",
                "subsections": []
            },
            "DESCRIPTION": {
                "content": "DROP TRANSFORM removes a previously defined transform.\n\nTo be able to drop a transform, you must own the type and the language. These are the same\nprivileges that are required to create a transform.\n",
                "subsections": []
            },
            "PARAMETERS": {
                "content": "IF EXISTS\nDo not throw an error if the transform does not exist. A notice is issued in this case.\n\ntypename\nThe name of the data type of the transform.\n\nlangname\nThe name of the language of the transform.\n\nCASCADE\nAutomatically drop objects that depend on the transform, and in turn all objects that\ndepend on those objects (see Section 5.14).\n\nRESTRICT\nRefuse to drop the transform if any objects depend on it. This is the default.\n",
                "subsections": []
            },
            "EXAMPLES": {
                "content": "To drop the transform for type hstore and language plpythonu:\n\nDROP TRANSFORM FOR hstore LANGUAGE plpythonu;\n",
                "subsections": []
            },
            "COMPATIBILITY": {
                "content": "This form of DROP TRANSFORM is a PostgreSQL extension. See CREATE TRANSFORM\n(CREATETRANSFORM(7)) for details.\n",
                "subsections": []
            },
            "SEE ALSO": {
                "content": "CREATE TRANSFORM (CREATETRANSFORM(7))\n\n\n\nPostgreSQL 14.23                                2026                               DROP TRANSFORM(7)",
                "subsections": []
            }
        }
    }
}