{
    "content": [
        {
            "type": "text",
            "text": "# DROP_EXTENSION (man)\n\n## NAME\n\nDROPEXTENSION - remove an extension\n\n## SYNOPSIS\n\nDROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]\n\n## DESCRIPTION\n\nDROP EXTENSION removes extensions from the database. Dropping an extension causes its member\nobjects, and other explicitly dependent routines (see ALTER ROUTINE (ALTERROUTINE(7)), the\nDEPENDS ON EXTENSION extensionname action), to be dropped as well.\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_EXTENSION",
        "section": "",
        "mode": "man",
        "summary": "DROPEXTENSION - remove an extension",
        "synopsis": "DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]",
        "tldr_summary": null,
        "tldr_examples": [],
        "tldr_source": null,
        "flags": [],
        "examples": [
            "To remove the extension hstore from the current database:",
            "DROP EXTENSION hstore;",
            "This command will fail if any of hstore's objects are in use in the database, for example if",
            "any tables have columns of the hstore type. Add the CASCADE option to forcibly remove those",
            "dependent objects as well."
        ],
        "see_also": [
            {
                "name": "CREATEEXTENSION",
                "section": "7",
                "url": "https://www.chedong.com/phpMan.php/man/CREATEEXTENSION/7/json"
            },
            {
                "name": "ALTEREXTENSION",
                "section": "7",
                "url": "https://www.chedong.com/phpMan.php/man/ALTEREXTENSION/7/json"
            },
            {
                "name": "EXTENSION",
                "section": "7",
                "url": "https://www.chedong.com/phpMan.php/man/EXTENSION/7/json"
            }
        ],
        "section_outline": [
            {
                "name": "NAME",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SYNOPSIS",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "DESCRIPTION",
                "lines": 6,
                "subsections": []
            },
            {
                "name": "PARAMETERS",
                "lines": 15,
                "subsections": []
            },
            {
                "name": "EXAMPLES",
                "lines": 8,
                "subsections": []
            },
            {
                "name": "COMPATIBILITY",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SEE ALSO",
                "lines": 5,
                "subsections": []
            }
        ],
        "sections": {
            "NAME": {
                "content": "DROPEXTENSION - remove an extension\n",
                "subsections": []
            },
            "SYNOPSIS": {
                "content": "DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]\n",
                "subsections": []
            },
            "DESCRIPTION": {
                "content": "DROP EXTENSION removes extensions from the database. Dropping an extension causes its member\nobjects, and other explicitly dependent routines (see ALTER ROUTINE (ALTERROUTINE(7)), the\nDEPENDS ON EXTENSION extensionname action), to be dropped as well.\n\nYou must own the extension to use DROP EXTENSION.\n",
                "subsections": []
            },
            "PARAMETERS": {
                "content": "IF EXISTS\nDo not throw an error if the extension does not exist. A notice is issued in this case.\n\nname\nThe name of an installed extension.\n\nCASCADE\nAutomatically drop objects that depend on the extension, and in turn all objects that\ndepend on those objects (see Section 5.14).\n\nRESTRICT\nThis option prevents the specified extensions from being dropped if other objects,\nbesides these extensions, their members, and their explicitly dependent routines, depend\non them. This is the default.\n",
                "subsections": []
            },
            "EXAMPLES": {
                "content": "To remove the extension hstore from the current database:\n\nDROP EXTENSION hstore;\n\nThis command will fail if any of hstore's objects are in use in the database, for example if\nany tables have columns of the hstore type. Add the CASCADE option to forcibly remove those\ndependent objects as well.\n",
                "subsections": []
            },
            "COMPATIBILITY": {
                "content": "DROP EXTENSION is a PostgreSQL extension.\n",
                "subsections": []
            },
            "SEE ALSO": {
                "content": "CREATE EXTENSION (CREATEEXTENSION(7)), ALTER EXTENSION (ALTEREXTENSION(7))\n\n\n\nPostgreSQL 14.23                                2026                               DROP EXTENSION(7)",
                "subsections": []
            }
        }
    }
}