{"kind": "psql", "major": "18", "item": {"slug": "cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64", "name": "\\close_prepared", "name_zh": "", "category": "Query execution", "summary": "Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op.", "aliases": ["\\close_prepared"], "content_hash": "0ace0b98bb248467bbbe8b6e798179490ef60fb46fdb5d80064556106bb8ae90", "versions": {"18": {"facts": [{"label": "Client", "value": "psql 18.6"}, {"label": "Case-sensitive spelling", "value": "\\close_prepared"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64/?v=18", "text": "\\close_prepared"}, "modifiers": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\close_prepared", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql command-line options and complete manual"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-CLOSE-PREPARED", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c"}], "sections": [], "modifiers": [], "signature": "\\close_prepared prepared_statement_name", "spellings": ["\\close_prepared"], "description": ["Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-CLOSE-PREPARED\"><span class=\"term\"><code class=\"literal\">\\close_prepared</code> <em class=\"replaceable\"><code>prepared_statement_name</code></em></span> </dt><dd>\n<p>Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op.</p>\n<p>Example:</p>\n<pre class=\"programlisting\">SELECT $1 \\parse stmt1\n\\close_prepared stmt1\n</pre>\n<p>This command causes the extended query protocol to be used, unlike normal <span class=\"application\">psql</span> operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from <span class=\"application\">psql</span>.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED", "comparison_data": {"modifiers": [], "signature": "\\close_prepared prepared_statement_name", "spellings": ["\\close_prepared"], "definition": "Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op. Example: SELECT $1 \\parse stmt1 \\close_prepared stmt1 This command causes the extended query protocol to be used, unlike normal psql operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from psql ."}, "comparison_hash": "a429097da746d7cc72c4687c6eedc74180a11ef8013888767ed80b807bfb62dc"}, "19": {"facts": [{"label": "Client", "value": "psql 19beta4"}, {"label": "Case-sensitive spelling", "value": "\\close_prepared"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64/?v=19", "text": "\\close_prepared"}, "modifiers": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\close_prepared", "related": [{"url": "/wiki/tool/psql/?v=19", "label": "psql command-line options and complete manual"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/19/postgresql-19-A4.pdf", "bytes": 16064841, "pages": 3052, "sha256": "4dd099e4125c591128fc5f3ebd02178dc24781f9e5ae629f96d67c4c8547427b", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/19/postgresql-19-US.pdf", "bytes": 15974616, "pages": 3225, "sha256": "61971fa857f0956d47341a0388fa6af9ae10acf691d4b2fc009007d384b0342b", "built_at": "2026-09-26"}}, "tree": "19", "index": "index.html", "major": "19", "pages": 1155, "release": "19beta4", "source_url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "svg_assets": 5, "source_mode": "en SGML built with pinned official archive", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "revision": "1bbbbf4133d426f0e4304010688d2984c30fb67df0cc3a61b3e37eb3f6f37833", "evidence_kind": "English manual and source declarations", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "/docs/19/app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED", "file": "app-psql.html", "label": "19beta4 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-CLOSE-PREPARED", "sha256": "312975c12d6e4d62aeebcb5e98e7ca795c6d07ecb743b4bc64403dc42bc2a6e9"}], "sections": [], "modifiers": [], "signature": "\\close_prepared prepared_statement_name", "spellings": ["\\close_prepared"], "description": ["Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-CLOSE-PREPARED\"><span class=\"term\"><code class=\"literal\">\\close_prepared</code> <em class=\"replaceable\"><code>prepared_statement_name</code></em></span> </dt><dd>\n<p>Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op.</p>\n<p>Example:</p>\n<pre class=\"programlisting\">SELECT $1 \\parse stmt1\n\\close_prepared stmt1\n</pre>\n<p>This command causes the extended query protocol to be used, unlike normal <span class=\"application\">psql</span> operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from <span class=\"application\">psql</span>.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED", "comparison_data": {"modifiers": [], "signature": "\\close_prepared prepared_statement_name", "spellings": ["\\close_prepared"], "definition": "Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op. Example: SELECT $1 \\parse stmt1 \\close_prepared stmt1 This command causes the extended query protocol to be used, unlike normal psql operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from psql ."}, "comparison_hash": "a429097da746d7cc72c4687c6eedc74180a11ef8013888767ed80b807bfb62dc"}, "20": {"facts": [{"label": "Client", "value": "psql 20devel"}, {"label": "Case-sensitive spelling", "value": "\\close_prepared"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64/?v=20", "text": "\\close_prepared"}, "modifiers": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\close_prepared", "related": [{"url": "/wiki/tool/psql/?v=20", "label": "psql command-line options and complete manual"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/20/postgresql-20-A4.pdf", "bytes": 16030631, "pages": 3052, "sha256": "bd5d82c0ce38fc18f92a0447818a91a193a261776bca1c37564bf9a683e177d0", "built_at": "2026-09-28"}, "US": {"url": "/files/documentation/pdf/20/postgresql-20-US.pdf", "bytes": 15936613, "pages": 3223, "sha256": "d97d9e0db479a02f4234b175f50fcad70c3661619afc8d6df9b9437882e3c299", "built_at": "2026-09-28"}}, "tree": "0", "index": "index.html", "major": "20", "pages": 1156, "release": "20devel", "source_url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "svg_assets": 6, "source_mode": "en SGML built with pinned official archive", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_snapshot_utc": "26-Sep-2026 20:22"}, "revision": "2eba5e0fd4c3bffb2803247b6cd537878e9d6ee5a6dfbe3c50ece8b421b80918", "evidence_kind": "English manual and source declarations", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-CLOSE-PREPARED", "sha256": "6df5f6fbaff7800ae0e4a08a3116090d890a0cdcc02fddc31c1f220725905f87"}], "sections": [], "modifiers": [], "signature": "\\close_prepared prepared_statement_name", "spellings": ["\\close_prepared"], "description": ["Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-CLOSE-PREPARED\"><span class=\"term\"><code class=\"literal\">\\close_prepared</code> <em class=\"replaceable\"><code>prepared_statement_name</code></em></span> </dt><dd>\n<p>Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op.</p>\n<p>Example:</p>\n<pre class=\"programlisting\">SELECT $1 \\parse stmt1\n\\close_prepared stmt1\n</pre>\n<p>This command causes the extended query protocol to be used, unlike normal <span class=\"application\">psql</span> operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from <span class=\"application\">psql</span>.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED", "comparison_data": {"modifiers": [], "signature": "\\close_prepared prepared_statement_name", "spellings": ["\\close_prepared"], "definition": "Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op. Example: SELECT $1 \\parse stmt1 \\close_prepared stmt1 This command causes the extended query protocol to be used, unlike normal psql operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from psql ."}, "comparison_hash": "a429097da746d7cc72c4687c6eedc74180a11ef8013888767ed80b807bfb62dc"}}}, "snapshot": {"facts": [{"label": "Client", "value": "psql 18.6"}, {"label": "Case-sensitive spelling", "value": "\\close_prepared"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64/?v=18", "text": "\\close_prepared"}, "modifiers": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\close_prepared", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql command-line options and complete manual"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-CLOSE-PREPARED", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c"}], "sections": [], "modifiers": [], "signature": "\\close_prepared prepared_statement_name", "spellings": ["\\close_prepared"], "description": ["Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-CLOSE-PREPARED\"><span class=\"term\"><code class=\"literal\">\\close_prepared</code> <em class=\"replaceable\"><code>prepared_statement_name</code></em></span> </dt><dd>\n<p>Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op.</p>\n<p>Example:</p>\n<pre class=\"programlisting\">SELECT $1 \\parse stmt1\n\\close_prepared stmt1\n</pre>\n<p>This command causes the extended query protocol to be used, unlike normal <span class=\"application\">psql</span> operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from <span class=\"application\">psql</span>.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED", "comparison_data": {"modifiers": [], "signature": "\\close_prepared prepared_statement_name", "spellings": ["\\close_prepared"], "definition": "Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op. Example: SELECT $1 \\parse stmt1 \\close_prepared stmt1 This command causes the extended query protocol to be used, unlike normal psql operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from psql ."}, "comparison_hash": "a429097da746d7cc72c4687c6eedc74180a11ef8013888767ed80b807bfb62dc"}, "comparison": {"left": "17", "right": "18", "status": "added", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1 +1,8 @@\n-Not recorded in this version\n+{\n+  \"definition\": \"Closes the specified prepared statement. An empty string denotes the unnamed prepared statement. If no prepared statement exists with this name, the operation is a no-op. Example: SELECT $1 \\\\parse stmt1 \\\\close_prepared stmt1 This command causes the extended query protocol to be used, unlike normal psql operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from psql .\",\n+  \"modifiers\": [],\n+  \"signature\": \"\\\\close_prepared prepared_statement_name\",\n+  \"spellings\": [\n+    \"\\\\close_prepared\"\n+  ]\n+}"}}