{"kind": "psql", "major": "18", "item": {"slug": "cmd-66-6c-75-73-68", "name": "\\flush", "name_zh": "", "category": "\u67e5\u8be2\u6267\u884c", "summary": "\u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 \\startpipeline \u5f00\u59cb\uff0c\u5e76\u4ee5 \\endpipeline \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 \\syncpipeline \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761 \u540c\u6b65\u6d88\u606f \uff0c\u800c\u4e0d\u4f1a\u7ed3\u675f\u5f53\u524d\u7ba1\u9053\uff0c\u4e5f\u4e0d\u4f1a\u5237\u65b0\u53d1\u9001\u7f13\u51b2\u533a\u3002\u5728\u7ba1\u9053\u6a21\u5f0f\u4e0b\uff0c\u8bed\u53e5\u4f1a\u88ab\u53d1\u9001\u5230\u670d\u52a1\u5668\uff0c\u800c\u4e0d\u7b49\u5f85\u524d\u9762\u8bed\u53e5\u7684\u7ed3\u679c\u3002\u66f4\u591a\u7ec6\u8282\u89c1 \u7b2c 32.5 \u8282 \u3002", "aliases": ["\\flush"], "content_hash": "315e48533961758380d4a8ea811fe97f1f2c2b9a4c2f6442f3dec1b907fdebef", "versions": {"18": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\flush"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-73-74-61-72-74-70-69-70-65-6c-69-6e-65/?v=18", "text": "\\startpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-73-65-6e-64-70-69-70-65-6c-69-6e-65/?v=18", "text": "\\sendpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-73-79-6e-63-70-69-70-65-6c-69-6e-65/?v=18", "text": "\\syncpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-65-6e-64-70-69-70-65-6c-69-6e-65/?v=18", "text": "\\endpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-66-6c-75-73-68-72-65-71-75-65-73-74/?v=18", "text": "\\flushrequest"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=18", "text": "\\flush"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-67-65-74-72-65-73-75-6c-74-73/?v=18", "text": "\\getresults"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\flush", "related": [{"url": "/wiki/psql/cmd-73-74-61-72-74-70-69-70-65-6c-69-6e-65/?v=18", "label": "\\startpipeline"}, {"url": "/wiki/psql/cmd-73-65-6e-64-70-69-70-65-6c-69-6e-65/?v=18", "label": "\\sendpipeline"}, {"url": "/wiki/psql/cmd-73-79-6e-63-70-69-70-65-6c-69-6e-65/?v=18", "label": "\\syncpipeline"}, {"url": "/wiki/psql/cmd-65-6e-64-70-69-70-65-6c-69-6e-65/?v=18", "label": "\\endpipeline"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68-72-65-71-75-65-73-74/?v=18", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-67-65-74-72-65-73-75-6c-74-73/?v=18", "label": "\\getresults"}, {"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "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": "https://pg.center/docs/18/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-PIPELINE", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE"}], "sections": [], "modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "description": ["\u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 \\startpipeline \u5f00\u59cb\uff0c\u5e76\u4ee5 \\endpipeline \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 \\syncpipeline \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761 \u540c\u6b65\u6d88\u606f \uff0c\u800c\u4e0d\u4f1a\u7ed3\u675f\u5f53\u524d\u7ba1\u9053\uff0c\u4e5f\u4e0d\u4f1a\u5237\u65b0\u53d1\u9001\u7f13\u51b2\u533a\u3002\u5728\u7ba1\u9053\u6a21\u5f0f\u4e0b\uff0c\u8bed\u53e5\u4f1a\u88ab\u53d1\u9001\u5230\u670d\u52a1\u5668\uff0c\u800c\u4e0d\u7b49\u5f85\u524d\u9762\u8bed\u53e5\u7684\u7ed3\u679c\u3002\u66f4\u591a\u7ec6\u8282\u89c1 \u7b2c 32.5 \u8282 \u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-PIPELINE\"><span class=\"term\"><code class=\"literal\">\\startpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\sendpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\syncpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\endpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\flushrequest</code><br/></span><span class=\"term\"><code class=\"literal\">\\flush</code><br/></span><span class=\"term\"><code class=\"literal\">\\getresults [ <em class=\"replaceable\"><code>number_results</code></em> ]</code></span> </dt><dd>\n<p lang=\"zh\">\u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 <code class=\"command\">\\startpipeline</code> \u5f00\u59cb\uff0c\u5e76\u4ee5 <code class=\"command\">\\endpipeline</code> \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 <code class=\"command\">\\syncpipeline</code> \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761<a class=\"link\" href=\"/docs/18/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY\" title=\"54.2.3.\u00a0\u6269\u5c55\u67e5\u8be2\">\u540c\u6b65\u6d88\u606f</a>\uff0c\u800c\u4e0d\u4f1a\u7ed3\u675f\u5f53\u524d\u7ba1\u9053\uff0c\u4e5f\u4e0d\u4f1a\u5237\u65b0\u53d1\u9001\u7f13\u51b2\u533a\u3002\u5728\u7ba1\u9053\u6a21\u5f0f\u4e0b\uff0c\u8bed\u53e5\u4f1a\u88ab\u53d1\u9001\u5230\u670d\u52a1\u5668\uff0c\u800c\u4e0d\u7b49\u5f85\u524d\u9762\u8bed\u53e5\u7684\u7ed3\u679c\u3002\u66f4\u591a\u7ec6\u8282\u89c1<a class=\"xref\" href=\"/docs/18/libpq-pipeline-mode.html\" title=\"32.5.\u00a0\u7ba1\u9053\u6a21\u5f0f\">\u7b2c\u00a032.5\u00a0\u8282</a>\u3002</p>\n<p lang=\"zh\">\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\u6267\u884c\u7684\u6240\u6709\u67e5\u8be2\u90fd\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\u4ee5\u5206\u53f7\u7ed3\u675f\u7684\u67e5\u8be2\u4f1a\u88ab\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5143\u547d\u4ee4 <code class=\"literal\">\\bind</code>\u3001<code class=\"literal\">\\bind_named</code>\u3001<code class=\"literal\">\\close_prepared</code> \u548c <code class=\"literal\">\\parse</code> \u53ef\u4ee5\u5728\u8fdb\u884c\u4e2d\u7684\u7ba1\u9053\u91cc\u4f7f\u7528\u3002\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\uff0c<code class=\"literal\">\\sendpipeline</code> \u4f1a\u5c06\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5176\u4ed6\u5143\u547d\u4ee4\uff0c\u5982 <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216 <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002</p>\n<p lang=\"zh\"><code class=\"command\">\\flushrequest</code> \u4f1a\u5411\u7ba1\u9053\u8ffd\u52a0\u4e00\u6761 flush \u547d\u4ee4\uff0c\u4f7f\u5f97\u53ef\u4ee5\u5728\u4e0d\u53d1\u9001 sync \u6216\u7ed3\u675f\u7ba1\u9053\u7684\u60c5\u51b5\u4e0b\u901a\u8fc7 <code class=\"command\">\\getresults</code> \u8bfb\u53d6\u7ed3\u679c\u3002<code class=\"command\">\\getresults</code> \u4f1a\u81ea\u52a8\u5c06\u5c1a\u672a\u53d1\u9001\u7684\u6570\u636e\u63a8\u9001\u5230\u670d\u52a1\u5668\u3002<code class=\"command\">\\flush</code> \u53ef\u7528\u4e8e\u624b\u52a8\u63a8\u9001\u672a\u53d1\u9001\u7684\u6570\u636e\u3002</p>\n<p lang=\"zh\"><code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684 <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d <em class=\"replaceable\"><code>number_results</code></em> \u4e2a\u5f85\u5904\u7406\u7ed3\u679c\u3002\u82e5\u7701\u7565\u8be5\u53c2\u6570\u6216\u5176\u503c\u4e3a <code class=\"literal\">0</code>\uff0c\u5219\u8bfb\u53d6\u6240\u6709\u5f85\u5904\u7406\u7ed3\u679c\u3002</p>\n<p lang=\"zh\">\u5f53\u7ba1\u9053\u6a21\u5f0f\u5904\u4e8e\u6d3b\u52a8\u72b6\u6001\u65f6\uff0c\u53ef\u4f7f\u7528\u4e00\u4e2a\u4e13\u7528\u7684\u63d0\u793a\u7b26\u53d8\u91cf\u6765\u62a5\u544a\u7ba1\u9053\u72b6\u6001\u3002\u8be6\u89c1<a class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-PROMPTING-P-UC\"><code class=\"literal\">%P</code></a>\u3002</p>\n<p lang=\"zh\"><code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002</p>\n<p lang=\"zh\">\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "localization": {"status": "complete", "sources": [{"url": "/docs/18/app-psql.html", "method": "same-major semantic node", "sha256": "4ff5633229e0afa7feecc2750a7187d2d45a7eef0ca8febc73e4e5c15ac7fa6d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[1]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[2]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[3]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[4]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[5]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[3]/p[1]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "This group of commands implements pipelining of SQL statements. A pipeline must begin with a \\startpipeline and end with an \\endpipeline . In between there may be any number of \\syncpipeline commands, which sends a sync message without ending the ongoing pipeline and flushing the send buffer. In pipeline mode, statements are sent to the server without waiting for the results of previous statements. See Section 32.5 for more details.", "/versions/18/facts/0/label": "Client", "/versions/18/facts/1/label": "Case-sensitive spelling", "/versions/18/tables/0/title": "Spellings in this manual definition", "/versions/18/related/6/label": "psql command-line options and complete manual", "/versions/18/tables/0/columns/0/label": "Command", "/versions/18/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/18/tables/0/rows/0/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/1/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/2/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/3/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/4/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/5/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/6/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "6badaf5a0bc23850f89ce2083719725a5be867494456355beac763a6477f1fab"}, "comparison_data": {"modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "definition": "This group of commands implements pipelining of SQL statements. A pipeline must begin with a \\startpipeline and end with an \\endpipeline . In between there may be any number of \\syncpipeline commands, which sends a sync message without ending the ongoing pipeline and flushing the send buffer. In pipeline mode, statements are sent to the server without waiting for the results of previous statements. See Section 32.5 for more details. All queries executed while a pipeline is ongoing use the extended query protocol. Queries are appended to the pipeline when ending with a semicolon. The meta-commands \\bind , \\bind_named , \\close_prepared or \\parse can be used in an ongoing pipeline. While a pipeline is ongoing, \\sendpipeline will append the current query buffer to the pipeline. Other meta-commands like \\g , \\gx or \\gdesc are not allowed in pipeline mode. \\flushrequest appends a flush command to the pipeline, allowing to read results with \\getresults without issuing a sync or ending the pipeline. \\getresults will automatically push unsent data to the server. \\flush can be used to manually push unsent data. \\getresults accepts an optional number_results parameter. If provided, only the first number_results pending results will be read. If not provided or 0 , all pending results are read. When pipeline mode is active, a dedicated prompt variable is available to report the pipeline status. See %P for more details COPY is not supported while in pipeline mode. Example: \\startpipeline SELECT * FROM pg_class; SELECT 1 \\bind \\sendpipeline \\flushrequest \\getresults \\endpipeline"}, "comparison_hash": "040a9956ba3780370b72d9837a83079a03b641afd0cd9f7e39a7b0c0dc62127e", "manual_language": "zh"}, "19": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19beta4"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\flush"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-73-74-61-72-74-70-69-70-65-6c-69-6e-65/?v=19", "text": "\\startpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-73-65-6e-64-70-69-70-65-6c-69-6e-65/?v=19", "text": "\\sendpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-73-79-6e-63-70-69-70-65-6c-69-6e-65/?v=19", "text": "\\syncpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-65-6e-64-70-69-70-65-6c-69-6e-65/?v=19", "text": "\\endpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-66-6c-75-73-68-72-65-71-75-65-73-74/?v=19", "text": "\\flushrequest"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=19", "text": "\\flush"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-67-65-74-72-65-73-75-6c-74-73/?v=19", "text": "\\getresults"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\flush", "related": [{"url": "/wiki/psql/cmd-73-74-61-72-74-70-69-70-65-6c-69-6e-65/?v=19", "label": "\\startpipeline"}, {"url": "/wiki/psql/cmd-73-65-6e-64-70-69-70-65-6c-69-6e-65/?v=19", "label": "\\sendpipeline"}, {"url": "/wiki/psql/cmd-73-79-6e-63-70-69-70-65-6c-69-6e-65/?v=19", "label": "\\syncpipeline"}, {"url": "/wiki/psql/cmd-65-6e-64-70-69-70-65-6c-69-6e-65/?v=19", "label": "\\endpipeline"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68-72-65-71-75-65-73-74/?v=19", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-67-65-74-72-65-73-75-6c-74-73/?v=19", "label": "\\getresults"}, {"url": "/wiki/tool/psql/?v=19", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "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": "https://pg.center/docs/19/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "file": "app-psql.html", "label": "19beta4 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-PIPELINE", "sha256": "312975c12d6e4d62aeebcb5e98e7ca795c6d07ecb743b4bc64403dc42bc2a6e9", "language": "en", "original_url": "/docs/19/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE"}], "sections": [], "modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "description": ["\u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 \\startpipeline \u5f00\u59cb\uff0c\u5e76\u4ee5 \\endpipeline \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 \\syncpipeline \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761 \u540c\u6b65\u6d88\u606f \uff0c\u800c\u4e0d\u4f1a\u7ed3\u675f\u5f53\u524d\u7ba1\u9053\uff0c\u4e5f\u4e0d\u4f1a\u5237\u65b0\u53d1\u9001\u7f13\u51b2\u533a\u3002\u5728\u7ba1\u9053\u6a21\u5f0f\u4e0b\uff0c\u8bed\u53e5\u4f1a\u88ab\u53d1\u9001\u5230\u670d\u52a1\u5668\uff0c\u800c\u4e0d\u7b49\u5f85\u524d\u9762\u8bed\u53e5\u7684\u7ed3\u679c\u3002\u66f4\u591a\u7ec6\u8282\u89c1 \u7b2c 32.5 \u8282 \u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-PIPELINE\"><span class=\"term\"><code class=\"literal\">\\startpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\sendpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\syncpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\endpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\flushrequest</code><br/></span><span class=\"term\"><code class=\"literal\">\\flush</code><br/></span><span class=\"term\"><code class=\"literal\">\\getresults [ <em class=\"replaceable\"><code>number_results</code></em> ]</code></span> </dt><dd>\n<p lang=\"zh\">\u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 <code class=\"command\">\\startpipeline</code> \u5f00\u59cb\uff0c\u5e76\u4ee5 <code class=\"command\">\\endpipeline</code> \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 <code class=\"command\">\\syncpipeline</code> \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761<a class=\"link\" href=\"/docs/19/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY\" title=\"54.2.3.\u00a0\u6269\u5c55\u67e5\u8be2\">\u540c\u6b65\u6d88\u606f</a>\uff0c\u800c\u4e0d\u4f1a\u7ed3\u675f\u5f53\u524d\u7ba1\u9053\uff0c\u4e5f\u4e0d\u4f1a\u5237\u65b0\u53d1\u9001\u7f13\u51b2\u533a\u3002\u5728\u7ba1\u9053\u6a21\u5f0f\u4e0b\uff0c\u8bed\u53e5\u4f1a\u88ab\u53d1\u9001\u5230\u670d\u52a1\u5668\uff0c\u800c\u4e0d\u7b49\u5f85\u524d\u9762\u8bed\u53e5\u7684\u7ed3\u679c\u3002\u66f4\u591a\u7ec6\u8282\u89c1<a class=\"xref\" href=\"/docs/19/libpq-pipeline-mode.html\" title=\"32.5.\u00a0\u7ba1\u9053\u6a21\u5f0f\">\u7b2c\u00a032.5\u00a0\u8282</a>\u3002</p>\n<p lang=\"zh\">\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\u6267\u884c\u7684\u6240\u6709\u67e5\u8be2\u90fd\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\u4ee5\u5206\u53f7\u7ed3\u675f\u7684\u67e5\u8be2\u4f1a\u88ab\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5143\u547d\u4ee4 <code class=\"literal\">\\bind</code>\u3001<code class=\"literal\">\\bind_named</code>\u3001<code class=\"literal\">\\close_prepared</code> \u548c <code class=\"literal\">\\parse</code> \u53ef\u4ee5\u5728\u8fdb\u884c\u4e2d\u7684\u7ba1\u9053\u91cc\u4f7f\u7528\u3002\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\uff0c<code class=\"literal\">\\sendpipeline</code> \u4f1a\u5c06\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5176\u4ed6\u5143\u547d\u4ee4\uff0c\u5982 <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216 <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002</p>\n<p lang=\"zh\"><code class=\"command\">\\flushrequest</code> \u4f1a\u5411\u7ba1\u9053\u8ffd\u52a0\u4e00\u6761 flush \u547d\u4ee4\uff0c\u4f7f\u5f97\u53ef\u4ee5\u5728\u4e0d\u53d1\u9001 sync \u6216\u7ed3\u675f\u7ba1\u9053\u7684\u60c5\u51b5\u4e0b\u901a\u8fc7 <code class=\"command\">\\getresults</code> \u8bfb\u53d6\u7ed3\u679c\u3002<code class=\"command\">\\getresults</code> \u4f1a\u81ea\u52a8\u5c06\u5c1a\u672a\u53d1\u9001\u7684\u6570\u636e\u63a8\u9001\u5230\u670d\u52a1\u5668\u3002<code class=\"command\">\\flush</code> \u53ef\u7528\u4e8e\u624b\u52a8\u63a8\u9001\u672a\u53d1\u9001\u7684\u6570\u636e\u3002</p>\n<p lang=\"zh\"><code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684 <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d <em class=\"replaceable\"><code>number_results</code></em> \u4e2a\u5f85\u5904\u7406\u7ed3\u679c\u3002\u82e5\u7701\u7565\u8be5\u53c2\u6570\u6216\u5176\u503c\u4e3a <code class=\"literal\">0</code>\uff0c\u5219\u8bfb\u53d6\u6240\u6709\u5f85\u5904\u7406\u7ed3\u679c\u3002</p>\n<p lang=\"zh\">\u5f53\u7ba1\u9053\u6a21\u5f0f\u5904\u4e8e\u6d3b\u52a8\u72b6\u6001\u65f6\uff0c\u53ef\u4f7f\u7528\u4e00\u4e2a\u4e13\u7528\u7684\u63d0\u793a\u7b26\u53d8\u91cf\u6765\u62a5\u544a\u7ba1\u9053\u72b6\u6001\u3002\u8be6\u89c1<a class=\"xref\" href=\"/docs/19/app-psql.html#APP-PSQL-PROMPTING-P-UC\"><code class=\"literal\">%P</code></a>\u3002</p>\n<p lang=\"zh\"><code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002</p>\n<p lang=\"zh\">\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "localization": {"status": "complete", "sources": [{"url": "/docs/19/app-psql.html", "method": "same-major semantic node", "sha256": "1351be06967585f99a84454a26dff346091ea378daf6c7ed9fa18edee9d1131c", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[1]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[2]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[3]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[4]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[5]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[3]/p[1]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "This group of commands implements pipelining of SQL statements. A pipeline must begin with a \\startpipeline and end with an \\endpipeline . In between there may be any number of \\syncpipeline commands, which sends a sync message without ending the ongoing pipeline and flushing the send buffer. In pipeline mode, statements are sent to the server without waiting for the results of previous statements. See Section 32.5 for more details.", "/versions/19/facts/0/label": "Client", "/versions/19/facts/1/label": "Case-sensitive spelling", "/versions/19/tables/0/title": "Spellings in this manual definition", "/versions/19/related/6/label": "psql command-line options and complete manual", "/versions/19/tables/0/columns/0/label": "Command", "/versions/19/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/19/tables/0/rows/0/modifiers": "None listed in this signature", "/versions/19/tables/0/rows/1/modifiers": "None listed in this signature", "/versions/19/tables/0/rows/2/modifiers": "None listed in this signature", "/versions/19/tables/0/rows/3/modifiers": "None listed in this signature", "/versions/19/tables/0/rows/4/modifiers": "None listed in this signature", "/versions/19/tables/0/rows/5/modifiers": "None listed in this signature", "/versions/19/tables/0/rows/6/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "7b3722528a51736cef4024ed7fe35524d19195f8af078edc9e7f90a6790244a9"}, "comparison_data": {"modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "definition": "This group of commands implements pipelining of SQL statements. A pipeline must begin with a \\startpipeline and end with an \\endpipeline . In between there may be any number of \\syncpipeline commands, which sends a sync message without ending the ongoing pipeline and flushing the send buffer. In pipeline mode, statements are sent to the server without waiting for the results of previous statements. See Section 32.5 for more details. All queries executed while a pipeline is ongoing use the extended query protocol. Queries are appended to the pipeline when ending with a semicolon. The meta-commands \\bind , \\bind_named , \\close_prepared or \\parse can be used in an ongoing pipeline. While a pipeline is ongoing, \\sendpipeline will append the current query buffer to the pipeline. Other meta-commands like \\g , \\gx or \\gdesc are not allowed in pipeline mode. \\flushrequest appends a flush command to the pipeline, allowing to read results with \\getresults without issuing a sync or ending the pipeline. \\getresults will automatically push unsent data to the server. \\flush can be used to manually push unsent data. \\getresults accepts an optional number_results parameter. If provided, only the first number_results pending results will be read. If not provided or 0 , all pending results are read. When pipeline mode is active, a dedicated prompt variable is available to report the pipeline status. See %P for more details COPY is not supported while in pipeline mode. Example: \\startpipeline SELECT * FROM pg_class; SELECT 1 \\bind \\sendpipeline \\flushrequest \\getresults \\endpipeline"}, "comparison_hash": "040a9956ba3780370b72d9837a83079a03b641afd0cd9f7e39a7b0c0dc62127e", "manual_language": "zh"}, "20": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\flush"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-73-74-61-72-74-70-69-70-65-6c-69-6e-65/?v=20", "text": "\\startpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-73-65-6e-64-70-69-70-65-6c-69-6e-65/?v=20", "text": "\\sendpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-73-79-6e-63-70-69-70-65-6c-69-6e-65/?v=20", "text": "\\syncpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-65-6e-64-70-69-70-65-6c-69-6e-65/?v=20", "text": "\\endpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-66-6c-75-73-68-72-65-71-75-65-73-74/?v=20", "text": "\\flushrequest"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=20", "text": "\\flush"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-67-65-74-72-65-73-75-6c-74-73/?v=20", "text": "\\getresults"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\flush", "related": [{"url": "/wiki/psql/cmd-73-74-61-72-74-70-69-70-65-6c-69-6e-65/?v=20", "label": "\\startpipeline"}, {"url": "/wiki/psql/cmd-73-65-6e-64-70-69-70-65-6c-69-6e-65/?v=20", "label": "\\sendpipeline"}, {"url": "/wiki/psql/cmd-73-79-6e-63-70-69-70-65-6c-69-6e-65/?v=20", "label": "\\syncpipeline"}, {"url": "/wiki/psql/cmd-65-6e-64-70-69-70-65-6c-69-6e-65/?v=20", "label": "\\endpipeline"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68-72-65-71-75-65-73-74/?v=20", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-67-65-74-72-65-73-75-6c-74-73/?v=20", "label": "\\getresults"}, {"url": "/wiki/tool/psql/?v=20", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "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": "https://pg.center/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-PIPELINE", "sha256": "6df5f6fbaff7800ae0e4a08a3116090d890a0cdcc02fddc31c1f220725905f87", "language": "en", "original_url": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE"}], "sections": [], "modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "description": ["\u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 \\startpipeline \u5f00\u59cb\uff0c\u5e76\u4ee5 \\endpipeline \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 \\syncpipeline \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761 \u540c\u6b65\u6d88\u606f \uff0c\u800c\u4e0d\u4f1a\u7ed3\u675f\u5f53\u524d\u7ba1\u9053\uff0c\u4e5f\u4e0d\u4f1a\u5237\u65b0\u53d1\u9001\u7f13\u51b2\u533a\u3002\u5728\u7ba1\u9053\u6a21\u5f0f\u4e0b\uff0c\u8bed\u53e5\u4f1a\u88ab\u53d1\u9001\u5230\u670d\u52a1\u5668\uff0c\u800c\u4e0d\u7b49\u5f85\u524d\u9762\u8bed\u53e5\u7684\u7ed3\u679c\u3002\u66f4\u591a\u7ec6\u8282\u89c1 \u7b2c 32.5 \u8282 \u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-PIPELINE\"><span class=\"term\"><code class=\"literal\">\\startpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\sendpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\syncpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\endpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\flushrequest</code><br/></span><span class=\"term\"><code class=\"literal\">\\flush</code><br/></span><span class=\"term\"><code class=\"literal\">\\getresults [ <em class=\"replaceable\"><code>number_results</code></em> ]</code></span> </dt><dd>\n<p lang=\"zh\">\u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 <code class=\"command\">\\startpipeline</code> \u5f00\u59cb\uff0c\u5e76\u4ee5 <code class=\"command\">\\endpipeline</code> \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 <code class=\"command\">\\syncpipeline</code> \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761<a class=\"link\" href=\"/docs/devel/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY\" title=\"54.2.3.\u00a0\u6269\u5c55\u67e5\u8be2\">\u540c\u6b65\u6d88\u606f</a>\uff0c\u800c\u4e0d\u4f1a\u7ed3\u675f\u5f53\u524d\u7ba1\u9053\uff0c\u4e5f\u4e0d\u4f1a\u5237\u65b0\u53d1\u9001\u7f13\u51b2\u533a\u3002\u5728\u7ba1\u9053\u6a21\u5f0f\u4e0b\uff0c\u8bed\u53e5\u4f1a\u88ab\u53d1\u9001\u5230\u670d\u52a1\u5668\uff0c\u800c\u4e0d\u7b49\u5f85\u524d\u9762\u8bed\u53e5\u7684\u7ed3\u679c\u3002\u66f4\u591a\u7ec6\u8282\u89c1<a class=\"xref\" href=\"/docs/devel/libpq-pipeline-mode.html\" title=\"32.5.\u00a0\u7ba1\u9053\u6a21\u5f0f\">\u7b2c\u00a032.5\u00a0\u8282</a>\u3002</p>\n<p lang=\"zh\">\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\u6267\u884c\u7684\u6240\u6709\u67e5\u8be2\u90fd\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\u4ee5\u5206\u53f7\u7ed3\u675f\u7684\u67e5\u8be2\u4f1a\u88ab\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5143\u547d\u4ee4 <code class=\"literal\">\\bind</code>\u3001<code class=\"literal\">\\bind_named</code>\u3001<code class=\"literal\">\\close_prepared</code> \u548c <code class=\"literal\">\\parse</code> \u53ef\u4ee5\u5728\u8fdb\u884c\u4e2d\u7684\u7ba1\u9053\u91cc\u4f7f\u7528\u3002\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\uff0c<code class=\"literal\">\\sendpipeline</code> \u4f1a\u5c06\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5176\u4ed6\u5143\u547d\u4ee4\uff0c\u5982 <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216 <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002</p>\n<p lang=\"zh\"><code class=\"command\">\\flushrequest</code> \u4f1a\u5411\u7ba1\u9053\u8ffd\u52a0\u4e00\u6761 flush \u547d\u4ee4\uff0c\u4f7f\u5f97\u53ef\u4ee5\u5728\u4e0d\u53d1\u9001 sync \u6216\u7ed3\u675f\u7ba1\u9053\u7684\u60c5\u51b5\u4e0b\u901a\u8fc7 <code class=\"command\">\\getresults</code> \u8bfb\u53d6\u7ed3\u679c\u3002<code class=\"command\">\\getresults</code> \u4f1a\u81ea\u52a8\u5c06\u5c1a\u672a\u53d1\u9001\u7684\u6570\u636e\u63a8\u9001\u5230\u670d\u52a1\u5668\u3002<code class=\"command\">\\flush</code> \u53ef\u7528\u4e8e\u624b\u52a8\u63a8\u9001\u672a\u53d1\u9001\u7684\u6570\u636e\u3002</p>\n<p lang=\"zh\"><code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684 <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d <em class=\"replaceable\"><code>number_results</code></em> \u4e2a\u5f85\u5904\u7406\u7ed3\u679c\u3002\u82e5\u7701\u7565\u8be5\u53c2\u6570\u6216\u5176\u503c\u4e3a <code class=\"literal\">0</code>\uff0c\u5219\u8bfb\u53d6\u6240\u6709\u5f85\u5904\u7406\u7ed3\u679c\u3002</p>\n<p lang=\"zh\">\u5f53\u7ba1\u9053\u6a21\u5f0f\u5904\u4e8e\u6d3b\u52a8\u72b6\u6001\u65f6\uff0c\u53ef\u4f7f\u7528\u4e00\u4e2a\u4e13\u7528\u7684\u63d0\u793a\u7b26\u53d8\u91cf\u6765\u62a5\u544a\u7ba1\u9053\u72b6\u6001\u3002\u8be6\u89c1<a class=\"xref\" href=\"/docs/devel/app-psql.html#APP-PSQL-PROMPTING-P-UC\"><code class=\"literal\">%P</code></a>\u3002</p>\n<p lang=\"zh\"><code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002</p>\n<p lang=\"zh\">\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "localization": {"status": "complete", "sources": [{"url": "/docs/devel/app-psql.html", "method": "same-major semantic node", "sha256": "1590b6e290ad21fe3ac1c1549628841ae426d1cd07a8f808789207878dbee5ab", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[1]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[2]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[3]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[4]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[5]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[3]/p[1]"]}], "language": "zh", "original_text": {"/summary": "This group of commands implements pipelining of SQL statements. A pipeline must begin with a \\startpipeline and end with an \\endpipeline . In between there may be any number of \\syncpipeline commands, which sends a sync message without ending the ongoing pipeline and flushing the send buffer. In pipeline mode, statements are sent to the server without waiting for the results of previous statements. See Section 32.5 for more details.", "/category": "Query execution", "/versions/20/description/0": "This group of commands implements pipelining of SQL statements. A pipeline must begin with a \\startpipeline and end with an \\endpipeline . In between there may be any number of \\syncpipeline commands, which sends a sync message without ending the ongoing pipeline and flushing the send buffer. In pipeline mode, statements are sent to the server without waiting for the results of previous statements. See Section 32.5 for more details.", "/versions/20/facts/0/label": "Client", "/versions/20/facts/1/label": "Case-sensitive spelling", "/versions/20/tables/0/title": "Spellings in this manual definition", "/versions/20/related/6/label": "psql command-line options and complete manual", "/versions/20/tables/0/columns/0/label": "Command", "/versions/20/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/20/tables/0/rows/0/modifiers": "None listed in this signature", "/versions/20/tables/0/rows/1/modifiers": "None listed in this signature", "/versions/20/tables/0/rows/2/modifiers": "None listed in this signature", "/versions/20/tables/0/rows/3/modifiers": "None listed in this signature", "/versions/20/tables/0/rows/4/modifiers": "None listed in this signature", "/versions/20/tables/0/rows/5/modifiers": "None listed in this signature", "/versions/20/tables/0/rows/6/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f1a4b2b5c9e310bde6238b60ce333367bef862cb1c162bbede75978dda2c512a"}, "comparison_data": {"modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "definition": "This group of commands implements pipelining of SQL statements. A pipeline must begin with a \\startpipeline and end with an \\endpipeline . In between there may be any number of \\syncpipeline commands, which sends a sync message without ending the ongoing pipeline and flushing the send buffer. In pipeline mode, statements are sent to the server without waiting for the results of previous statements. See Section 32.5 for more details. All queries executed while a pipeline is ongoing use the extended query protocol. Queries are appended to the pipeline when ending with a semicolon. The meta-commands \\bind , \\bind_named , \\close_prepared or \\parse can be used in an ongoing pipeline. While a pipeline is ongoing, \\sendpipeline will append the current query buffer to the pipeline. Other meta-commands like \\g , \\gx or \\gdesc are not allowed in pipeline mode. \\flushrequest appends a flush command to the pipeline, allowing to read results with \\getresults without issuing a sync or ending the pipeline. \\getresults will automatically push unsent data to the server. \\flush can be used to manually push unsent data. \\getresults accepts an optional number_results parameter. If provided, only the first number_results pending results will be read. If not provided or 0 , all pending results are read. When pipeline mode is active, a dedicated prompt variable is available to report the pipeline status. See %P for more details COPY is not supported while in pipeline mode. Example: \\startpipeline SELECT * FROM pg_class; SELECT 1 \\bind \\sendpipeline \\flushrequest \\getresults \\endpipeline"}, "comparison_hash": "040a9956ba3780370b72d9837a83079a03b641afd0cd9f7e39a7b0c0dc62127e", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\flush"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-73-74-61-72-74-70-69-70-65-6c-69-6e-65/?v=18", "text": "\\startpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-73-65-6e-64-70-69-70-65-6c-69-6e-65/?v=18", "text": "\\sendpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-73-79-6e-63-70-69-70-65-6c-69-6e-65/?v=18", "text": "\\syncpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-65-6e-64-70-69-70-65-6c-69-6e-65/?v=18", "text": "\\endpipeline"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-66-6c-75-73-68-72-65-71-75-65-73-74/?v=18", "text": "\\flushrequest"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=18", "text": "\\flush"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}, {"command": {"url": "/wiki/psql/cmd-67-65-74-72-65-73-75-6c-74-73/?v=18", "text": "\\getresults"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\flush", "related": [{"url": "/wiki/psql/cmd-73-74-61-72-74-70-69-70-65-6c-69-6e-65/?v=18", "label": "\\startpipeline"}, {"url": "/wiki/psql/cmd-73-65-6e-64-70-69-70-65-6c-69-6e-65/?v=18", "label": "\\sendpipeline"}, {"url": "/wiki/psql/cmd-73-79-6e-63-70-69-70-65-6c-69-6e-65/?v=18", "label": "\\syncpipeline"}, {"url": "/wiki/psql/cmd-65-6e-64-70-69-70-65-6c-69-6e-65/?v=18", "label": "\\endpipeline"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68-72-65-71-75-65-73-74/?v=18", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-67-65-74-72-65-73-75-6c-74-73/?v=18", "label": "\\getresults"}, {"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "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": "https://pg.center/docs/18/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-PIPELINE", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE"}], "sections": [], "modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "description": ["\u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 \\startpipeline \u5f00\u59cb\uff0c\u5e76\u4ee5 \\endpipeline \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 \\syncpipeline \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761 \u540c\u6b65\u6d88\u606f \uff0c\u800c\u4e0d\u4f1a\u7ed3\u675f\u5f53\u524d\u7ba1\u9053\uff0c\u4e5f\u4e0d\u4f1a\u5237\u65b0\u53d1\u9001\u7f13\u51b2\u533a\u3002\u5728\u7ba1\u9053\u6a21\u5f0f\u4e0b\uff0c\u8bed\u53e5\u4f1a\u88ab\u53d1\u9001\u5230\u670d\u52a1\u5668\uff0c\u800c\u4e0d\u7b49\u5f85\u524d\u9762\u8bed\u53e5\u7684\u7ed3\u679c\u3002\u66f4\u591a\u7ec6\u8282\u89c1 \u7b2c 32.5 \u8282 \u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-PIPELINE\"><span class=\"term\"><code class=\"literal\">\\startpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\sendpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\syncpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\endpipeline</code><br/></span><span class=\"term\"><code class=\"literal\">\\flushrequest</code><br/></span><span class=\"term\"><code class=\"literal\">\\flush</code><br/></span><span class=\"term\"><code class=\"literal\">\\getresults [ <em class=\"replaceable\"><code>number_results</code></em> ]</code></span> </dt><dd>\n<p lang=\"zh\">\u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 <code class=\"command\">\\startpipeline</code> \u5f00\u59cb\uff0c\u5e76\u4ee5 <code class=\"command\">\\endpipeline</code> \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 <code class=\"command\">\\syncpipeline</code> \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761<a class=\"link\" href=\"/docs/18/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY\" title=\"54.2.3.\u00a0\u6269\u5c55\u67e5\u8be2\">\u540c\u6b65\u6d88\u606f</a>\uff0c\u800c\u4e0d\u4f1a\u7ed3\u675f\u5f53\u524d\u7ba1\u9053\uff0c\u4e5f\u4e0d\u4f1a\u5237\u65b0\u53d1\u9001\u7f13\u51b2\u533a\u3002\u5728\u7ba1\u9053\u6a21\u5f0f\u4e0b\uff0c\u8bed\u53e5\u4f1a\u88ab\u53d1\u9001\u5230\u670d\u52a1\u5668\uff0c\u800c\u4e0d\u7b49\u5f85\u524d\u9762\u8bed\u53e5\u7684\u7ed3\u679c\u3002\u66f4\u591a\u7ec6\u8282\u89c1<a class=\"xref\" href=\"/docs/18/libpq-pipeline-mode.html\" title=\"32.5.\u00a0\u7ba1\u9053\u6a21\u5f0f\">\u7b2c\u00a032.5\u00a0\u8282</a>\u3002</p>\n<p lang=\"zh\">\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\u6267\u884c\u7684\u6240\u6709\u67e5\u8be2\u90fd\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\u4ee5\u5206\u53f7\u7ed3\u675f\u7684\u67e5\u8be2\u4f1a\u88ab\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5143\u547d\u4ee4 <code class=\"literal\">\\bind</code>\u3001<code class=\"literal\">\\bind_named</code>\u3001<code class=\"literal\">\\close_prepared</code> \u548c <code class=\"literal\">\\parse</code> \u53ef\u4ee5\u5728\u8fdb\u884c\u4e2d\u7684\u7ba1\u9053\u91cc\u4f7f\u7528\u3002\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\uff0c<code class=\"literal\">\\sendpipeline</code> \u4f1a\u5c06\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5176\u4ed6\u5143\u547d\u4ee4\uff0c\u5982 <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216 <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002</p>\n<p lang=\"zh\"><code class=\"command\">\\flushrequest</code> \u4f1a\u5411\u7ba1\u9053\u8ffd\u52a0\u4e00\u6761 flush \u547d\u4ee4\uff0c\u4f7f\u5f97\u53ef\u4ee5\u5728\u4e0d\u53d1\u9001 sync \u6216\u7ed3\u675f\u7ba1\u9053\u7684\u60c5\u51b5\u4e0b\u901a\u8fc7 <code class=\"command\">\\getresults</code> \u8bfb\u53d6\u7ed3\u679c\u3002<code class=\"command\">\\getresults</code> \u4f1a\u81ea\u52a8\u5c06\u5c1a\u672a\u53d1\u9001\u7684\u6570\u636e\u63a8\u9001\u5230\u670d\u52a1\u5668\u3002<code class=\"command\">\\flush</code> \u53ef\u7528\u4e8e\u624b\u52a8\u63a8\u9001\u672a\u53d1\u9001\u7684\u6570\u636e\u3002</p>\n<p lang=\"zh\"><code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684 <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d <em class=\"replaceable\"><code>number_results</code></em> \u4e2a\u5f85\u5904\u7406\u7ed3\u679c\u3002\u82e5\u7701\u7565\u8be5\u53c2\u6570\u6216\u5176\u503c\u4e3a <code class=\"literal\">0</code>\uff0c\u5219\u8bfb\u53d6\u6240\u6709\u5f85\u5904\u7406\u7ed3\u679c\u3002</p>\n<p lang=\"zh\">\u5f53\u7ba1\u9053\u6a21\u5f0f\u5904\u4e8e\u6d3b\u52a8\u72b6\u6001\u65f6\uff0c\u53ef\u4f7f\u7528\u4e00\u4e2a\u4e13\u7528\u7684\u63d0\u793a\u7b26\u53d8\u91cf\u6765\u62a5\u544a\u7ba1\u9053\u72b6\u6001\u3002\u8be6\u89c1<a class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-PROMPTING-P-UC\"><code class=\"literal\">%P</code></a>\u3002</p>\n<p lang=\"zh\"><code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002</p>\n<p lang=\"zh\">\u793a\u4f8b\uff1a</p>\n<pre class=\"programlisting\">\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "localization": {"status": "complete", "sources": [{"url": "/docs/18/app-psql.html", "method": "same-major semantic node", "sha256": "4ff5633229e0afa7feecc2750a7187d2d45a7eef0ca8febc73e4e5c15ac7fa6d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[1]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[2]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[3]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[4]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[181]/p[5]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[3]/p[1]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "This group of commands implements pipelining of SQL statements. A pipeline must begin with a \\startpipeline and end with an \\endpipeline . In between there may be any number of \\syncpipeline commands, which sends a sync message without ending the ongoing pipeline and flushing the send buffer. In pipeline mode, statements are sent to the server without waiting for the results of previous statements. See Section 32.5 for more details.", "/versions/18/facts/0/label": "Client", "/versions/18/facts/1/label": "Case-sensitive spelling", "/versions/18/tables/0/title": "Spellings in this manual definition", "/versions/18/related/6/label": "psql command-line options and complete manual", "/versions/18/tables/0/columns/0/label": "Command", "/versions/18/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/18/tables/0/rows/0/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/1/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/2/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/3/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/4/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/5/modifiers": "None listed in this signature", "/versions/18/tables/0/rows/6/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "6badaf5a0bc23850f89ce2083719725a5be867494456355beac763a6477f1fab"}, "comparison_data": {"modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "definition": "This group of commands implements pipelining of SQL statements. A pipeline must begin with a \\startpipeline and end with an \\endpipeline . In between there may be any number of \\syncpipeline commands, which sends a sync message without ending the ongoing pipeline and flushing the send buffer. In pipeline mode, statements are sent to the server without waiting for the results of previous statements. See Section 32.5 for more details. All queries executed while a pipeline is ongoing use the extended query protocol. Queries are appended to the pipeline when ending with a semicolon. The meta-commands \\bind , \\bind_named , \\close_prepared or \\parse can be used in an ongoing pipeline. While a pipeline is ongoing, \\sendpipeline will append the current query buffer to the pipeline. Other meta-commands like \\g , \\gx or \\gdesc are not allowed in pipeline mode. \\flushrequest appends a flush command to the pipeline, allowing to read results with \\getresults without issuing a sync or ending the pipeline. \\getresults will automatically push unsent data to the server. \\flush can be used to manually push unsent data. \\getresults accepts an optional number_results parameter. If provided, only the first number_results pending results will be read. If not provided or 0 , all pending results are read. When pipeline mode is active, a dedicated prompt variable is available to report the pipeline status. See %P for more details COPY is not supported while in pipeline mode. Example: \\startpipeline SELECT * FROM pg_class; SELECT 1 \\bind \\sendpipeline \\flushrequest \\getresults \\endpipeline"}, "comparison_hash": "040a9956ba3780370b72d9837a83079a03b641afd0cd9f7e39a7b0c0dc62127e", "manual_language": "zh"}, "comparison": {"left": "17", "right": "18", "status": "added", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1 +1,14 @@\n-\u8be5\u7248\u672a\u6536\u5f55\n+{\n+  \"definition\": \"This group of commands implements pipelining of SQL statements. A pipeline must begin with a \\\\startpipeline and end with an \\\\endpipeline . In between there may be any number of \\\\syncpipeline commands, which sends a sync message without ending the ongoing pipeline and flushing the send buffer. In pipeline mode, statements are sent to the server without waiting for the results of previous statements. See Section 32.5 for more details. All queries executed while a pipeline is ongoing use the extended query protocol. Queries are appended to the pipeline when ending with a semicolon. The meta-commands \\\\bind , \\\\bind_named , \\\\close_prepared or \\\\parse can be used in an ongoing pipeline. While a pipeline is ongoing, \\\\sendpipeline will append the current query buffer to the pipeline. Other meta-commands like \\\\g , \\\\gx or \\\\gdesc are not allowed in pipeline mode. \\\\flushrequest appends a flush command to the pipeline, allowing to read results with \\\\getresults without issuing a sync or ending the pipeline. \\\\getresults will automatically push unsent data to the server. \\\\flush can be used to manually push unsent data. \\\\getresults accepts an optional number_results parameter. If provided, only the first number_results pending results will be read. If not provided or 0 , all pending results are read. When pipeline mode is active, a dedicated prompt variable is available to report the pipeline status. See %P for more details COPY is not supported while in pipeline mode. Example: \\\\startpipeline SELECT * FROM pg_class; SELECT 1 \\\\bind \\\\sendpipeline \\\\flushrequest \\\\getresults \\\\endpipeline\",\n+  \"modifiers\": [],\n+  \"signature\": \"\\\\startpipeline \\\\sendpipeline \\\\syncpipeline \\\\endpipeline \\\\flushrequest \\\\flush \\\\getresults [ number_results ]\",\n+  \"spellings\": [\n+    \"\\\\startpipeline\",\n+    \"\\\\sendpipeline\",\n+    \"\\\\syncpipeline\",\n+    \"\\\\endpipeline\",\n+    \"\\\\flushrequest\",\n+    \"\\\\flush\",\n+    \"\\\\getresults\"\n+  ]\n+}"}}