{
    "mode": "man",
    "parameter": "DEALLOCATE",
    "section": "",
    "url": "https://www.chedong.com/phpMan.php/man/DEALLOCATE/json",
    "generated": "2026-10-22T12:52:12Z",
    "synopsis": "DEALLOCATE [ PREPARE ] { name | ALL }",
    "sections": {
        "NAME": {
            "content": "DEALLOCATE - deallocate a prepared statement\n",
            "subsections": []
        },
        "SYNOPSIS": {
            "content": "DEALLOCATE [ PREPARE ] { name | ALL }\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not\nexplicitly deallocate a prepared statement, it is deallocated when the session ends.\n\nFor more information on prepared statements, see PREPARE(7).\n",
            "subsections": []
        },
        "PARAMETERS": {
            "content": "PREPARE\nThis key word is ignored.\n\nname\nThe name of the prepared statement to deallocate.\n\nALL\nDeallocate all prepared statements.\n",
            "subsections": []
        },
        "COMPATIBILITY": {
            "content": "The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.\n",
            "subsections": []
        },
        "SEE ALSO": {
            "content": "EXECUTE(7), PREPARE(7)\n\nPostgreSQL 16.14                                2026                                   DEALLOCATE(7)",
            "subsections": []
        }
    },
    "summary": "DEALLOCATE - deallocate a prepared statement",
    "flags": [],
    "examples": [],
    "see_also": [
        {
            "name": "EXECUTE",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/EXECUTE/7/json"
        },
        {
            "name": "PREPARE",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/PREPARE/7/json"
        }
    ]
}