{
    "mode": "man",
    "parameter": "DROP_PUBLICATION",
    "section": "7",
    "url": "https://www.chedong.com/phpMan.php/man/DROP_PUBLICATION/7/json",
    "generated": "2026-06-15T14:38:54Z",
    "synopsis": "DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]",
    "sections": {
        "NAME": {
            "content": "DROPPUBLICATION - remove a publication\n",
            "subsections": []
        },
        "SYNOPSIS": {
            "content": "DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "DROP PUBLICATION removes an existing publication from the database.\n\nA publication can only be dropped by its owner or a superuser.\n",
            "subsections": []
        },
        "PARAMETERS": {
            "content": "IF EXISTS\nDo not throw an error if the publication does not exist. A notice is issued in this case.\n\nname\nThe name of an existing publication.\n\nCASCADE\nRESTRICT\nThese key words do not have any effect, since there are no dependencies on publications.\n",
            "subsections": []
        },
        "EXAMPLES": {
            "content": "Drop a publication:\n\nDROP PUBLICATION mypublication;\n",
            "subsections": []
        },
        "COMPATIBILITY": {
            "content": "DROP PUBLICATION is a PostgreSQL extension.\n",
            "subsections": []
        },
        "SEE ALSO": {
            "content": "CREATE PUBLICATION (CREATEPUBLICATION(7)), ALTER PUBLICATION (ALTERPUBLICATION(7))\n\n\n\nPostgreSQL 14.23                                2026                             DROP PUBLICATION(7)",
            "subsections": []
        }
    },
    "summary": "DROPPUBLICATION - remove a publication",
    "flags": [],
    "examples": [
        "Drop a publication:",
        "DROP PUBLICATION mypublication;"
    ],
    "see_also": [
        {
            "name": "CREATEPUBLICATION",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/CREATEPUBLICATION/7/json"
        },
        {
            "name": "ALTERPUBLICATION",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/ALTERPUBLICATION/7/json"
        },
        {
            "name": "PUBLICATION",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/PUBLICATION/7/json"
        }
    ]
}