{"kind": "psql", "major": "18", "item": {"slug": "cmd-65-6e-64-70-69-70-65-6c-69-6e-65", "name": "\\endpipeline", "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": ["\\endpipeline"], "content_hash": "98398a76521b0e78ac2e8fcf0bcf6317da1c6ad80eb03b77922f5b19f12a6b36", "versions": {"18": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.7"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\endpipeline"}], "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": "\\endpipeline", "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-66-6c-75-73-68-72-65-71-75-65-73-74/?v=18", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=18", "label": "\\flush"}, {"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.7/postgresql-18.7.tar.bz2", "label": "18.7", "major": "18", "channel": "stable", "manifest": {"major": "18", "release": "18.7", "source_url": "https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2", "source_sha256": "441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"}, "revision": "1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915", "evidence_kind": "English manual and source declarations", "source_sha256": "441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"}, "sources": [{"url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "file": "app-psql.html", "label": "18.7 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-PIPELINE", "sha256": "af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.7"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\endpipeline"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\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", "description_zh_html": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>"}, "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", "body_html": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>", "body_sha256": "4280f0efe18aa80ade0c12f809d1d1b45de3f81087c69f82d1b49731b79ad007", "content_hash": "f7a34eedd94fe281d1af22bdff5d7263b51585af32654917f8c48683f790a874", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "18", "documentation_release": "18.7"}, "modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "tables_zh": [{"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"}]}], "related_zh": [{"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-66-6c-75-73-68-72-65-71-75-65-73-74/?v=18", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=18", "label": "\\flush"}, {"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"}], "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": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "18.7"}, "description_zh": "\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", "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", "description_zh_html": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>", "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf", "version": "18.7"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b", "version": "18.7"}], "release": "18.7", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}, "center_zh_rendered": "<dl><dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd></dl>"}, "19": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19rc2"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\endpipeline"}], "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": "\\endpipeline", "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-66-6c-75-73-68-72-65-71-75-65-73-74/?v=19", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=19", "label": "\\flush"}, {"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/v19rc2/postgresql-19rc2.tar.bz2", "label": "19rc2", "major": "19", "channel": "preview", "manifest": {"major": "19", "release": "19rc2", "source_url": "https://ftp.postgresql.org/pub/source/v19rc2/postgresql-19rc2.tar.bz2", "source_sha256": "23a7bb862e4bac395c047305ed0084117b01e71255ce858b907cdcd78ce40351"}, "revision": "cd49a2a98fed04eec7571858125796f86e63613d1985225049f2aa8b0955f256", "evidence_kind": "English manual and source declarations", "source_sha256": "23a7bb862e4bac395c047305ed0084117b01e71255ce858b907cdcd78ce40351"}, "sources": [{"url": "/docs/19/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "file": "app-psql.html", "label": "19rc2 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-PIPELINE", "sha256": "88aeb3d77ad0a535a6a363215f0ac18936c368ac157e694ad30fea3c1ee30218"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19rc2"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\endpipeline"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\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", "description_zh_html": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>"}, "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", "body_html": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>", "body_sha256": "b528e6ae1c98f235e0a9e94a209b2d0a939cb7f9a898e74bdcea7e248674d66d", "content_hash": "d45d1e2f465c5fdf3de273396eab6c453047deeb7faf8dee97f02f47a99202da", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "19", "documentation_release": "19rc2"}, "modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "tables_zh": [{"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"}]}], "related_zh": [{"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-66-6c-75-73-68-72-65-71-75-65-73-74/?v=19", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=19", "label": "\\flush"}, {"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"}], "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": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "19rc2"}, "description_zh": "\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", "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", "description_zh_html": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>", "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "entity membership and source-derived facts; presentation markup normalized", "source_revision": "5e06fe0541cd1f62a9fc1a66c342c19a2944ff3c98281bfbdb1d4a6d6d53fe2f", "previous_source_revision": "1bbbbf4133d426f0e4304010688d2984c30fb67df0cc3a61b3e37eb3f6f37833"}, "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "88aeb3d77ad0a535a6a363215f0ac18936c368ac157e694ad30fea3c1ee30218", "version": "19rc2"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "7c244fc95f382349e2864e47925de5baa9fd870b49efe597bdf30e0ffc365f68", "version": "19rc2"}], "release": "19rc2", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}}, "20": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\endpipeline"}], "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": "\\endpipeline", "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-66-6c-75-73-68-72-65-71-75-65-73-74/?v=20", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=20", "label": "\\flush"}, {"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": {"major": "20", "release": "20devel", "source_url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "source_sha256": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2", "evidence_kind": "English manual and source declarations", "source_sha256": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "sources": [{"url": "/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": "4040ccb7cbcb1a83a43c150f5b92ddd10ff8837fdc27835b1863d4a316645676"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-identity", "manual": {"url": "/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "anchor": "APP-PSQL-META-COMMAND-PIPELINE", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "app-psql.html", "extraction": "exact-definition", "source_hash": "98935f3e8a333e7201e42b7315bb9e09d62e0711037964568c16bd22ae183680", "fragment_sha256": "20aa6bc7ec88bdc958d7d38d38183087eed3ee4a19d27655393bb0fc8509014b", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235", "translated_from_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "body_sha256": "ed3fbf5dbed08ceca198f0cfb551d15eeaec5078c3cd78ab8c16568d2a8d81a3", "runtime_rerun": false, "authored_translation": "source-derived-identity", "source_facts_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\endpipeline"}], "sections": [], "center_zh": {"title": "\\endpipeline", "locale": "zh-Hans", "source": {"key": "cmd-65-6e-64-70-69-70-65-6c-69-6e-65", "locale": "zh-Hans", "version": "20", "text_hash": "1d1dcaf4448ab35bdbc328c3838fada02a484775296ae6ba8b537e0e613c3340", "collection": "psql", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "payload": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\endpipeline"}], "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"}]}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-identity", "manual": {"url": "/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "anchor": "APP-PSQL-META-COMMAND-PIPELINE", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "app-psql.html", "extraction": "exact-definition", "source_hash": "98935f3e8a333e7201e42b7315bb9e09d62e0711037964568c16bd22ae183680", "fragment_sha256": "20aa6bc7ec88bdc958d7d38d38183087eed3ee4a19d27655393bb0fc8509014b", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235", "translated_from_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "body_sha256": "ed3fbf5dbed08ceca198f0cfb551d15eeaec5078c3cd78ab8c16568d2a8d81a3", "runtime_rerun": false, "authored_translation": "source-derived-identity", "source_facts_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "sections": [], "description_zh": "\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 \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 \\bind \u3001 \\bind_named \u3001 \\close_prepared \u548c \\parse \u53ef\u4ee5\u5728\u8fdb\u884c\u4e2d\u7684\u7ba1\u9053\u91cc\u4f7f\u7528\u3002\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\uff0c \\sendpipeline \u4f1a\u5c06\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5176\u4ed6\u5143\u547d\u4ee4\uff0c\u5982 \\g \u3001 \\gx \u6216 \\gdesc \uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002 \\flushrequest \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 \\getresults \u8bfb\u53d6\u7ed3\u679c\u3002 \\getresults \u4f1a\u81ea\u52a8\u5c06\u5c1a\u672a\u53d1\u9001\u7684\u6570\u636e\u63a8\u9001\u5230\u670d\u52a1\u5668\u3002 \\flush \u53ef\u7528\u4e8e\u624b\u52a8\u63a8\u9001\u672a\u53d1\u9001\u7684\u6570\u636e\u3002 \\getresults \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684 number_results \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d number_results \u4e2a\u5f85\u5904\u7406\u7ed3\u679c\u3002\u82e5\u7701\u7565\u8be5\u53c2\u6570\u6216\u5176\u503c\u4e3a 0 \uff0c\u5219\u8bfb\u53d6\u6240\u6709\u5f85\u5904\u7406\u7ed3\u679c\u3002 \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 %P \u3002 COPY \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002 \u793a\u4f8b\uff1a \\startpipeline SELECT * FROM pg_class; SELECT 1 \\bind \\sendpipeline \\flushrequest \\getresults \\endpipeline", "description_zh_html": "<p>psql \u547d\u4ee4 \\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]\u3002</p><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u5b9a\u4e49</h3><dd><p>\n        \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=\"/zh/docs/devel/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY\">\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=\"/zh/docs/devel/libpq-pipeline-mode.html\">\u7b2c\u00a032.5\u00a0\u8282</a>\u3002\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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=\"/zh/docs/devel/app-psql.html#APP-PSQL-PROMPTING-P-UC\"><code class=\"literal\">%P</code></a>\u3002\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd><p><a href=\"/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>"}, "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 \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 \\bind \u3001 \\bind_named \u3001 \\close_prepared \u548c \\parse \u53ef\u4ee5\u5728\u8fdb\u884c\u4e2d\u7684\u7ba1\u9053\u91cc\u4f7f\u7528\u3002\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\uff0c \\sendpipeline \u4f1a\u5c06\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5176\u4ed6\u5143\u547d\u4ee4\uff0c\u5982 \\g \u3001 \\gx \u6216 \\gdesc \uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002 \\flushrequest \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 \\getresults \u8bfb\u53d6\u7ed3\u679c\u3002 \\getresults \u4f1a\u81ea\u52a8\u5c06\u5c1a\u672a\u53d1\u9001\u7684\u6570\u636e\u63a8\u9001\u5230\u670d\u52a1\u5668\u3002 \\flush \u53ef\u7528\u4e8e\u624b\u52a8\u63a8\u9001\u672a\u53d1\u9001\u7684\u6570\u636e\u3002 \\getresults \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684 number_results \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d number_results \u4e2a\u5f85\u5904\u7406\u7ed3\u679c\u3002\u82e5\u7701\u7565\u8be5\u53c2\u6570\u6216\u5176\u503c\u4e3a 0 \uff0c\u5219\u8bfb\u53d6\u6240\u6709\u5f85\u5904\u7406\u7ed3\u679c\u3002 \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 %P \u3002 COPY \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002 \u793a\u4f8b\uff1a \\startpipeline SELECT * FROM pg_class; SELECT 1 \\bind \\sendpipeline \\flushrequest \\getresults \\endpipeline", "version": "20", "link_map": {"/zh/docs/devel/libpq-pipeline-mode.html": "/docs/devel/libpq-pipeline-mode.html", "/zh/docs/devel/app-psql.html#APP-PSQL-PROMPTING-P-UC": "/docs/devel/app-psql.html#APP-PSQL-PROMPTING-P-UC", "/zh/docs/devel/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY": "/docs/devel/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY", "/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE"}, "body_html": "<p>psql \u547d\u4ee4 \\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]\u3002</p><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u5b9a\u4e49</h3><dd><p>\n        \u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 <code>\\startpipeline</code> \u5f00\u59cb\uff0c\u5e76\u4ee5 <code>\\endpipeline</code> \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 <code>\\syncpipeline</code> \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761<a href=\"/zh/docs/devel/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY\" rel=\"nofollow\">\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 href=\"/zh/docs/devel/libpq-pipeline-mode.html\" rel=\"nofollow\">\u7b2c\u00a032.5\u00a0\u8282</a>\u3002\n       </p><p>\n        \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>\\bind</code>\u3001<code>\\bind_named</code>\u3001<code>\\close_prepared</code> \u548c\n        <code>\\parse</code> \u53ef\u4ee5\u5728\u8fdb\u884c\u4e2d\u7684\u7ba1\u9053\u91cc\u4f7f\u7528\u3002\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\uff0c<code>\\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\n        <code>\\g</code>\u3001<code>\\gx</code> \u6216\n        <code>\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<code>\\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\n        <code>\\getresults</code> \u8bfb\u53d6\u7ed3\u679c\u3002<code>\\getresults</code> \u4f1a\u81ea\u52a8\u5c06\u5c1a\u672a\u53d1\u9001\u7684\u6570\u636e\u63a8\u9001\u5230\u670d\u52a1\u5668\u3002<code>\\flush</code> \u53ef\u7528\u4e8e\u624b\u52a8\u63a8\u9001\u672a\u53d1\u9001\u7684\u6570\u636e\u3002\n       </p><p>\n<code>\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <em><code>number_results</code></em> \u4e2a\u5f85\u5904\u7406\u7ed3\u679c\u3002\u82e5\u7701\u7565\u8be5\u53c2\u6570\u6216\u5176\u503c\u4e3a <code>0</code>\uff0c\u5219\u8bfb\u53d6\u6240\u6709\u5f85\u5904\u7406\u7ed3\u679c\u3002\n       </p><p>\n        \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 href=\"/zh/docs/devel/app-psql.html#APP-PSQL-PROMPTING-P-UC\" rel=\"nofollow\"><code>%P</code></a>\u3002\n       </p><p>\n<code>COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre>\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd><p><a href=\"/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "body_sha256": "8af280f712670c272e3c7e24c314dd23b7bdc7ca7571267d2c0e0f2150da8678", "content_hash": "1d1dcaf4448ab35bdbc328c3838fada02a484775296ae6ba8b537e0e613c3340", "source_database": "center", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "tables_zh": [{"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"}]}], "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 \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 \\bind \u3001 \\bind_named \u3001 \\close_prepared \u548c \\parse \u53ef\u4ee5\u5728\u8fdb\u884c\u4e2d\u7684\u7ba1\u9053\u91cc\u4f7f\u7528\u3002\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\uff0c \\sendpipeline \u4f1a\u5c06\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5176\u4ed6\u5143\u547d\u4ee4\uff0c\u5982 \\g \u3001 \\gx \u6216 \\gdesc \uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002 \\flushrequest \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 \\getresults \u8bfb\u53d6\u7ed3\u679c\u3002 \\getresults \u4f1a\u81ea\u52a8\u5c06\u5c1a\u672a\u53d1\u9001\u7684\u6570\u636e\u63a8\u9001\u5230\u670d\u52a1\u5668\u3002 \\flush \u53ef\u7528\u4e8e\u624b\u52a8\u63a8\u9001\u672a\u53d1\u9001\u7684\u6570\u636e\u3002 \\getresults \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684 number_results \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d number_results \u4e2a\u5f85\u5904\u7406\u7ed3\u679c\u3002\u82e5\u7701\u7565\u8be5\u53c2\u6570\u6216\u5176\u503c\u4e3a 0 \uff0c\u5219\u8bfb\u53d6\u6240\u6709\u5f85\u5904\u7406\u7ed3\u679c\u3002 \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 %P \u3002 COPY \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002 \u793a\u4f8b\uff1a \\startpipeline SELECT * FROM pg_class; SELECT 1 \\bind \\sendpipeline \\flushrequest \\getresults \\endpipeline"], "manual_html": "", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "sections_zh": [], "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": "92a9ebf3ea6490b3fdf97689a4562b1bbd12ef1a04487580f00b205fd5f0cd31", "canonical_center_text_hash": "1d1dcaf4448ab35bdbc328c3838fada02a484775296ae6ba8b537e0e613c3340"}, "description_zh": "\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 \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 \\bind \u3001 \\bind_named \u3001 \\close_prepared \u548c \\parse \u53ef\u4ee5\u5728\u8fdb\u884c\u4e2d\u7684\u7ba1\u9053\u91cc\u4f7f\u7528\u3002\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\uff0c \\sendpipeline \u4f1a\u5c06\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\u8ffd\u52a0\u5230\u7ba1\u9053\u4e2d\u3002\u5176\u4ed6\u5143\u547d\u4ee4\uff0c\u5982 \\g \u3001 \\gx \u6216 \\gdesc \uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002 \\flushrequest \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 \\getresults \u8bfb\u53d6\u7ed3\u679c\u3002 \\getresults \u4f1a\u81ea\u52a8\u5c06\u5c1a\u672a\u53d1\u9001\u7684\u6570\u636e\u63a8\u9001\u5230\u670d\u52a1\u5668\u3002 \\flush \u53ef\u7528\u4e8e\u624b\u52a8\u63a8\u9001\u672a\u53d1\u9001\u7684\u6570\u636e\u3002 \\getresults \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684 number_results \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d number_results \u4e2a\u5f85\u5904\u7406\u7ed3\u679c\u3002\u82e5\u7701\u7565\u8be5\u53c2\u6570\u6216\u5176\u503c\u4e3a 0 \uff0c\u5219\u8bfb\u53d6\u6240\u6709\u5f85\u5904\u7406\u7ed3\u679c\u3002 \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 %P \u3002 COPY \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002 \u793a\u4f8b\uff1a \\startpipeline SELECT * FROM pg_class; SELECT 1 \\bind \\sendpipeline \\flushrequest \\getresults \\endpipeline", "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", "description_zh_html": "<p>psql \u547d\u4ee4 \\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]\u3002</p><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u5b9a\u4e49</h3><dd><p>\n        \u8fd9\u7ec4\u547d\u4ee4\u5b9e\u73b0 SQL \u8bed\u53e5\u7684\u7ba1\u9053\u5316\u3002\u4e00\u4e2a\u7ba1\u9053\u5fc5\u987b\u4ee5 <code>\\startpipeline</code> \u5f00\u59cb\uff0c\u5e76\u4ee5 <code>\\endpipeline</code> \u7ed3\u675f\u3002\u5176\u95f4\u53ef\u4ee5\u51fa\u73b0\u4efb\u610f\u6570\u91cf\u7684 <code>\\syncpipeline</code> \u547d\u4ee4\uff0c\u5b83\u4f1a\u53d1\u9001\u4e00\u6761<a href=\"/zh/docs/devel/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY\" rel=\"nofollow\">\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 href=\"/zh/docs/devel/libpq-pipeline-mode.html\" rel=\"nofollow\">\u7b2c\u00a032.5\u00a0\u8282</a>\u3002\n       </p><p>\n        \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>\\bind</code>\u3001<code>\\bind_named</code>\u3001<code>\\close_prepared</code> \u548c\n        <code>\\parse</code> \u53ef\u4ee5\u5728\u8fdb\u884c\u4e2d\u7684\u7ba1\u9053\u91cc\u4f7f\u7528\u3002\u7ba1\u9053\u8fdb\u884c\u671f\u95f4\uff0c<code>\\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\n        <code>\\g</code>\u3001<code>\\gx</code> \u6216\n        <code>\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<code>\\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\n        <code>\\getresults</code> \u8bfb\u53d6\u7ed3\u679c\u3002<code>\\getresults</code> \u4f1a\u81ea\u52a8\u5c06\u5c1a\u672a\u53d1\u9001\u7684\u6570\u636e\u63a8\u9001\u5230\u670d\u52a1\u5668\u3002<code>\\flush</code> \u53ef\u7528\u4e8e\u624b\u52a8\u63a8\u9001\u672a\u53d1\u9001\u7684\u6570\u636e\u3002\n       </p><p>\n<code>\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <em><code>number_results</code></em> \u4e2a\u5f85\u5904\u7406\u7ed3\u679c\u3002\u82e5\u7701\u7565\u8be5\u53c2\u6570\u6216\u5176\u503c\u4e3a <code>0</code>\uff0c\u5219\u8bfb\u53d6\u6240\u6709\u5f85\u5904\u7406\u7ed3\u679c\u3002\n       </p><p>\n        \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 href=\"/zh/docs/devel/app-psql.html#APP-PSQL-PROMPTING-P-UC\" rel=\"nofollow\"><code>%P</code></a>\u3002\n       </p><p>\n<code>COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre>\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd><p><a href=\"/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "entity membership and source-derived facts; presentation markup normalized", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2", "previous_source_revision": "2eba5e0fd4c3bffb2803247b6cd537878e9d6ee5a6dfbe3c50ece8b421b80918"}}}}, "snapshot": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.7"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\endpipeline"}], "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": "\\endpipeline", "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-66-6c-75-73-68-72-65-71-75-65-73-74/?v=18", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=18", "label": "\\flush"}, {"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.7/postgresql-18.7.tar.bz2", "label": "18.7", "major": "18", "channel": "stable", "manifest": {"major": "18", "release": "18.7", "source_url": "https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2", "source_sha256": "441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"}, "revision": "1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915", "evidence_kind": "English manual and source declarations", "source_sha256": "441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"}, "sources": [{"url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "file": "app-psql.html", "label": "18.7 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-PIPELINE", "sha256": "af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.7"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\endpipeline"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\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", "description_zh_html": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>"}, "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", "body_html": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>", "body_sha256": "4280f0efe18aa80ade0c12f809d1d1b45de3f81087c69f82d1b49731b79ad007", "content_hash": "f7a34eedd94fe281d1af22bdff5d7263b51585af32654917f8c48683f790a874", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "18", "documentation_release": "18.7"}, "modifiers": [], "signature": "\\startpipeline \\sendpipeline \\syncpipeline \\endpipeline \\flushrequest \\flush \\getresults [ number_results ]", "spellings": ["\\startpipeline", "\\sendpipeline", "\\syncpipeline", "\\endpipeline", "\\flushrequest", "\\flush", "\\getresults"], "tables_zh": [{"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"}]}], "related_zh": [{"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-66-6c-75-73-68-72-65-71-75-65-73-74/?v=18", "label": "\\flushrequest"}, {"url": "/wiki/psql/cmd-66-6c-75-73-68/?v=18", "label": "\\flush"}, {"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"}], "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": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-PIPELINE", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "18.7"}, "description_zh": "\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", "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", "description_zh_html": "<dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\n\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd>", "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf", "version": "18.7"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b", "version": "18.7"}], "release": "18.7", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}, "center_zh_rendered": "<dl><dd><p>\n        \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\n       </p><p>\n        \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\n        <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\n        <code class=\"literal\">\\g</code>\u3001<code class=\"literal\">\\gx</code> \u6216\n        <code class=\"literal\">\\gdesc</code>\uff0c\u5219\u4e0d\u5141\u8bb8\u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4f7f\u7528\u3002\n       </p><p>\n<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\n        <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\n       </p><p>\n<code class=\"command\">\\getresults</code> \u63a5\u53d7\u4e00\u4e2a\u53ef\u9009\u7684\n        <em class=\"replaceable\"><code>number_results</code></em> \u53c2\u6570\u3002\u5982\u679c\u63d0\u4f9b\uff0c\u5219\u53ea\u8bfb\u53d6\u524d\n        <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\n       </p><p>\n        \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\n       </p><p>\n<code class=\"command\">COPY</code> \u5728\u7ba1\u9053\u6a21\u5f0f\u4e2d\u4e0d\u652f\u6301\u3002\n       </p><p>\n        \u793a\u4f8b\uff1a\n</p><pre class=\"programlisting\">\\startpipeline\nSELECT * FROM pg_class;\nSELECT 1 \\bind \\sendpipeline\n\\flushrequest\n\\getresults\n\\endpipeline\n</pre><p>\n</p></dd></dl>"}, "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+}"}}