{"Entry":{"collection":"psql","key":"cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64","name":"\\close_prepared","aliases":["\\close_prepared"],"metadata":{"aliases":["\\close_prepared"],"category":"Query execution","content_hash":"0ace0b98bb248467bbbe8b6e798179490ef60fb46fdb5d80064556106bb8ae90","imported_at":"2026-09-30T00:40:44.721996+08:00","name":"\\close_prepared","name_zh":"","slug":"cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64","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."}},"Definition":{"Collection":"psql","Key":"cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","Facts":{"command":"\\close_prepared","comparison_data":{"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 .","modifiers":[],"signature":"\\close_prepared prepared_statement_name","spellings":["\\close_prepared"]},"comparison_hash":"a429097da746d7cc72c4687c6eedc74180a11ef8013888767ed80b807bfb62dc","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."],"facts":[{"label":"Client","value":"psql 18.6"},{"label":"Case-sensitive spelling","value":"\\close_prepared"}],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-CLOSE-PREPARED\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\close_prepared\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003eprepared_statement_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eCloses 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.\u003c/p\u003e\n\u003cp\u003eExample:\u003c/p\u003e\n\u003cpre class=\"programlisting\"\u003eSELECT $1 \\parse stmt1\n\\close_prepared stmt1\n\u003c/pre\u003e\n\u003cp\u003eThis command causes the extended query protocol to be used, unlike normal \u003cspan class=\"application\"\u003epsql\u003c/span\u003e operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from \u003cspan class=\"application\"\u003epsql\u003c/span\u003e.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED","modifiers":[],"related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[],"signature":"\\close_prepared prepared_statement_name","sources":[{"anchor":"APP-PSQL-META-COMMAND-CLOSE-PREPARED","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED"}],"spellings":["\\close_prepared"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\close_prepared","url":"/wiki/psql/cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-CLOSE-PREPARED","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-CLOSE-PREPARED"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\close_prepared","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.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-CLOSE-PREPARED\"\u003e\u003cspan\u003e\u003ccode\u003e\\close_prepared\u003c/code\u003e \u003cem\u003e\u003ccode\u003eprepared_statement_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eCloses 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.\u003c/p\u003e\n\u003cp\u003eExample:\u003c/p\u003e\n\u003cpre\u003eSELECT $1 \\parse stmt1\n\\close_prepared stmt1\n\u003c/pre\u003e\n\u003cp\u003eThis command causes the extended query protocol to be used, unlike normal \u003cspan\u003epsql\u003c/span\u003e operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from \u003cspan\u003epsql\u003c/span\u003e.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","ContentHash":"76b1850b6aadc128366cb07fc1c52673c8dae881ec37168dc1aa8a25c7a9a6bd","Payload":{"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":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-CLOSE-PREPARED\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\close_prepared\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003eprepared_statement_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eCloses 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.\u003c/p\u003e\n\u003cp\u003eExample:\u003c/p\u003e\n\u003cpre class=\"programlisting\"\u003eSELECT $1 \\parse stmt1\n\\close_prepared stmt1\n\u003c/pre\u003e\n\u003cp\u003eThis command causes the extended query protocol to be used, unlike normal \u003cspan class=\"application\"\u003epsql\u003c/span\u003e operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from \u003cspan class=\"application\"\u003epsql\u003c/span\u003e.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"sections":[],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\close_prepared","url":"/wiki/psql/cmd-63-6c-6f-73-65-5f-70-72-65-70-61-72-65-64/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\close_prepared","Signature":"\\close_prepared prepared_statement_name","Modifiers":[]}],"SQLState":null,"Evidence":null}