{
    "content": [
        {
            "type": "text",
            "text": "# DEALLOCATE (man)\n\n## NAME\n\nDEALLOCATE - deallocate a prepared statement\n\n## SYNOPSIS\n\nDEALLOCATE [ PREPARE ] { name | ALL }\n\n## DESCRIPTION\n\nDEALLOCATE 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\n## Sections\n\n- **NAME**\n- **SYNOPSIS**\n- **DESCRIPTION**\n- **PARAMETERS**\n- **COMPATIBILITY**\n- **SEE ALSO**\n\nUse structuredContent.sections for detailed options, examples, and full documentation.\n"
        }
    ],
    "structuredContent": {
        "command": "DEALLOCATE",
        "section": "",
        "mode": "man",
        "summary": "DEALLOCATE - deallocate a prepared statement",
        "synopsis": "DEALLOCATE [ PREPARE ] { name | ALL }",
        "tldr_summary": null,
        "tldr_examples": [],
        "tldr_source": null,
        "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"
            }
        ],
        "section_outline": [
            {
                "name": "NAME",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SYNOPSIS",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "DESCRIPTION",
                "lines": 5,
                "subsections": []
            },
            {
                "name": "PARAMETERS",
                "lines": 9,
                "subsections": []
            },
            {
                "name": "COMPATIBILITY",
                "lines": 2,
                "subsections": []
            },
            {
                "name": "SEE ALSO",
                "lines": 3,
                "subsections": []
            }
        ],
        "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 14.23                               2026                                 DEALLOCATE(7)",
                "subsections": []
            }
        }
    }
}