{"kind": "psql", "major": "18", "item": {"slug": "cmd-62-69-6e-64-5f-6e-61-6d-65-64", "name": "\\bind_named", "name_zh": "", "category": "\u67e5\u8be2\u6267\u884c", "summary": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002", "aliases": ["\\bind_named"], "content_hash": "8ce0699b0b026ab286c010faae129db00e1eef43a6f8356b811ccfeec2044a66", "versions": {"18": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.7"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\bind_named"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=18", "text": "\\bind_named"}, "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": "\\bind_named", "related": [{"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-BIND-NAMED", "file": "app-psql.html", "label": "18.7 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND-NAMED", "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": "\\bind_named"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002", "description_zh_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "summary": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002", "body_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

", "body_sha256": "7c289a62bb1d44b932bd5e043855624fee9568408f1189967a98b91276ab0b59", "content_hash": "402d4ab4d00631e55b511248b72f8dbb0e26de5a7b08665e62b8cfc4f38e1975", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "18", "documentation_release": "18.7"}, "modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=18", "text": "\\bind_named"}, "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/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002"], "manual_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "18.7"}, "description_zh": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002", "comparison_data": {"modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "definition": "\\bind_named is equivalent to \\bind , except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement. Example: INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1 \\bind_named stmt1 'first value' 'second value' \\g This command causes the extended query protocol (see Section 54.1.2 ) to be used, unlike normal psql operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from psql ."}, "comparison_hash": "d9d01fb7ba5e12d0ef1be5a90a7287c81155d001c968a0f72698117a9c9832e3", "manual_language": "zh", "description_zh_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

", "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": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "19": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19rc2"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\bind_named"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=19", "text": "\\bind_named"}, "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": "\\bind_named", "related": [{"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-BIND-NAMED", "file": "app-psql.html", "label": "19rc2 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND-NAMED", "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": "\\bind_named"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002", "description_zh_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "summary": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002", "body_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

", "body_sha256": "2d3f5b9ad38e1e018ee125cd044b3580e85af60f4fe88653a3515de57ee9ba00", "content_hash": "c63cc77db301466a1754fe743407f98f90fac0c1171ce56aa97a1c2263528f19", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "19", "documentation_release": "19rc2"}, "modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=19", "text": "\\bind_named"}, "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/tool/psql/?v=19", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002"], "manual_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "19rc2"}, "description_zh": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002", "comparison_data": {"modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "definition": "\\bind_named is equivalent to \\bind , except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement. Example: INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1 \\bind_named stmt1 'first value' 'second value' \\g This command causes the extended query protocol (see Section 54.1.2 ) to be used, unlike normal psql operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from psql ."}, "comparison_hash": "d9d01fb7ba5e12d0ef1be5a90a7287c81155d001c968a0f72698117a9c9832e3", "manual_language": "zh", "description_zh_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

", "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": "\\bind_named"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=20", "text": "\\bind_named"}, "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": "\\bind_named", "related": [{"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-BIND-NAMED", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND-NAMED", "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-BIND-NAMED", "anchor": "APP-PSQL-META-COMMAND-BIND-NAMED", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "app-psql.html", "extraction": "exact-definition", "source_hash": "98935f3e8a333e7201e42b7315bb9e09d62e0711037964568c16bd22ae183680", "fragment_sha256": "ee8b9fcd88df77cd699ca90e9991b8220ada42cd70076df67d5114b501ef794b", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235", "translated_from_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "body_sha256": "fb41faef069f4588eed975ab88ffd97ae96d4ec82eba25e1d74f4a01b3a8fe65", "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": "\\bind_named"}], "sections": [], "center_zh": {"title": "\\bind_named", "locale": "zh-Hans", "source": {"key": "cmd-62-69-6e-64-5f-6e-61-6d-65-64", "locale": "zh-Hans", "version": "20", "text_hash": "b1dd4c01316afd6018e6b984e884c672bd77c35fa75671aefa3c2eb4dfee94b2", "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": "\\bind_named"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=20", "text": "\\bind_named"}, "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-BIND-NAMED", "anchor": "APP-PSQL-META-COMMAND-BIND-NAMED", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "app-psql.html", "extraction": "exact-definition", "source_hash": "98935f3e8a333e7201e42b7315bb9e09d62e0711037964568c16bd22ae183680", "fragment_sha256": "ee8b9fcd88df77cd699ca90e9991b8220ada42cd70076df67d5114b501ef794b", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235", "translated_from_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "body_sha256": "fb41faef069f4588eed975ab88ffd97ae96d4ec82eba25e1d74f4a01b3a8fe65", "runtime_rerun": false, "authored_translation": "source-derived-identity", "source_facts_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "sections": [], "description_zh": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002 \u793a\u4f8b\uff1a INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1 \\bind_named stmt1 'first value' 'second value' \\g \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1 \u7b2c 54.1.2 \u8282 \uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002", "description_zh_html": "

psql \u547d\u4ee4 \\bind_named statement_name [ parameter ] ...\u3002

\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u5b9a\u4e49

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002

"}, "summary": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002 \u793a\u4f8b\uff1a INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1 \\bind_named stmt1 'first value' 'second value' \\g \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1 \u7b2c 54.1.2 \u8282 \uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002", "version": "20", "link_map": {"/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "/zh/docs/devel/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS": "/docs/devel/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS"}, "body_html": "

psql \u547d\u4ee4 \\bind_named statement_name [ parameter ] ...\u3002

\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u5b9a\u4e49

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002

", "body_sha256": "33214ef9b7ce30de16afadaf3f253c448f659c4e20381bc6a6ef5844dc428105", "content_hash": "b1dd4c01316afd6018e6b984e884c672bd77c35fa75671aefa3c2eb4dfee94b2", "source_database": "center", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=20", "text": "\\bind_named"}, "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": ["\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002 \u793a\u4f8b\uff1a INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1 \\bind_named stmt1 'first value' 'second value' \\g \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1 \u7b2c 54.1.2 \u8282 \uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002"], "manual_html": "", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "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[3]/p[1]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[5]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[5]/p[3]"]}], "language": "zh", "original_text": {"/summary": "\\bind_named is equivalent to \\bind , except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement.", "/category": "Query execution", "/versions/20/description/0": "\\bind_named is equivalent to \\bind , except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement.", "/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/0/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"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "b139dc888b1418ef650e09b0e75d65fc4d4987af4d139f7d7ac1faf9d6bbc288", "canonical_center_text_hash": "b1dd4c01316afd6018e6b984e884c672bd77c35fa75671aefa3c2eb4dfee94b2"}, "description_zh": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002 \u793a\u4f8b\uff1a INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1 \\bind_named stmt1 'first value' 'second value' \\g \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1 \u7b2c 54.1.2 \u8282 \uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002", "comparison_data": {"modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "definition": "\\bind_named is equivalent to \\bind , except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement. Example: INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1 \\bind_named stmt1 'first value' 'second value' \\g This command causes the extended query protocol (see Section 54.1.2 ) to be used, unlike normal psql operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from psql ."}, "comparison_hash": "d9d01fb7ba5e12d0ef1be5a90a7287c81155d001c968a0f72698117a9c9832e3", "manual_language": "zh", "description_zh_html": "

psql \u547d\u4ee4 \\bind_named statement_name [ parameter ] ...\u3002

\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u5b9a\u4e49

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002

", "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": "\\bind_named"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=18", "text": "\\bind_named"}, "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": "\\bind_named", "related": [{"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-BIND-NAMED", "file": "app-psql.html", "label": "18.7 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND-NAMED", "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": "\\bind_named"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002", "description_zh_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "summary": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002", "body_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

", "body_sha256": "7c289a62bb1d44b932bd5e043855624fee9568408f1189967a98b91276ab0b59", "content_hash": "402d4ab4d00631e55b511248b72f8dbb0e26de5a7b08665e62b8cfc4f38e1975", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "18", "documentation_release": "18.7"}, "modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=18", "text": "\\bind_named"}, "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/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002"], "manual_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "18.7"}, "description_zh": "\\bind_named \u7b49\u540c\u4e8e \\bind \uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002", "comparison_data": {"modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "definition": "\\bind_named is equivalent to \\bind , except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement. Example: INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1 \\bind_named stmt1 'first value' 'second value' \\g This command causes the extended query protocol (see Section 54.1.2 ) to be used, unlike normal psql operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from psql ."}, "comparison_hash": "d9d01fb7ba5e12d0ef1be5a90a7287c81155d001c968a0f72698117a9c9832e3", "manual_language": "zh", "description_zh_html": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

", "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": "

\n\\bind_named \u7b49\u540c\u4e8e \\bind\uff0c\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u628a\u73b0\u6709\u9884\u5907\u8bed\u53e5\u7684\u540d\u79f0\u4f5c\u4e3a\u7b2c\u4e00\u4e2a\u53c2\u6570\u3002\u7a7a\u5b57\u7b26\u4e32\u8868\u793a\u672a\u547d\u540d\u7684\u9884\u5907\u8bed\u53e5\u3002\n

\n \u793a\u4f8b\uff1a\n

INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n

\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a054.1.2\u00a0\u8282\uff09\uff0c\u4e0d\u540c\u4e8e psql \u901a\u5e38\u4f7f\u7528\u7684\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\u56e0\u6b64\uff0c\u53ef\u4ee5\u7528\u5b83\u5728 psql \u4e2d\u6d4b\u8bd5\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "comparison": {"left": "17", "right": "18", "status": "added", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1 +1,8 @@\n-\u8be5\u7248\u672a\u6536\u5f55\n+{\n+ \"definition\": \"\\\\bind_named is equivalent to \\\\bind , except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement. Example: INSERT INTO tbls1 VALUES ($1, $2) \\\\parse stmt1 \\\\bind_named stmt1 'first value' 'second value' \\\\g This command causes the extended query protocol (see Section 54.1.2 ) to be used, unlike normal psql operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from psql .\",\n+ \"modifiers\": [],\n+ \"signature\": \"\\\\bind_named statement_name [ parameter ] ...\",\n+ \"spellings\": [\n+ \"\\\\bind_named\"\n+ ]\n+}"}}