{"kind": "psql", "major": "18", "item": {"slug": "cmd-62-69-6e-64", "name": "\\bind", "name_zh": "", "category": "\u67e5\u8be2\u6267\u884c", "summary": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "aliases": ["\\bind"], "content_hash": "8313ff443f1e38225070e42b14e61b902ac77706028a1f4d3af88b5fcead8cc9", "versions": {"16": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 16.16"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\bind"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=16", "text": "\\bind"}, "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", "related": [{"url": "/wiki/tool/psql/?v=16", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.16/postgresql-16.16.tar.bz2", "label": "16.16", "major": "16", "channel": "stable", "manifest": {"major": "16", "release": "16.16", "source_url": "https://ftp.postgresql.org/pub/source/v16.16/postgresql-16.16.tar.bz2", "source_sha256": "9d5cd8633043b75740d5d59749c6b7365e6aeb53c47098b1a5e80bb18f87881a"}, "revision": "871ba8026d5a12aa5884ac4e6e77369dacd4b2bdbd835b2305f7dbae4ee7b50d", "evidence_kind": "English manual and source declarations", "source_sha256": "9d5cd8633043b75740d5d59749c6b7365e6aeb53c47098b1a5e80bb18f87881a"}, "sources": [{"url": "/docs/16/app-psql.html#APP-PSQL-META-COMMAND-BIND", "file": "app-psql.html", "label": "16.16 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "sha256": "6161d51dc66d54c8fd300944fed2bbae80efe4a532023b2e7771df5d94732330"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 16.16"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\bind"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "description_zh_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a055.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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "summary": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "body_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a055.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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "body_sha256": "1c9b3aab5b376ae15cc84712279300c2caf205f1e8fb1b46c7887862561eabbc", "content_hash": "ccfb2f36820abdb56fab2198f0fdf442871e67380b20c6fa16f06e882f034762", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "16", "documentation_release": "16.16"}, "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=16", "text": "\\bind"}, "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=16", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002"], "manual_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a055.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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "16.16"}, "description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "comparison_data": {"modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "definition": "Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.). Example: INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g This also works for query-execution commands besides \\g , such as \\gx and \\gset . This command causes the extended query protocol (see Section 55.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. (The extended query protocol is used even if the query has no parameters and this command specifies zero parameters.) This command affects only the next query executed; all subsequent queries will use the simple query protocol by default."}, "comparison_hash": "ecef0cc01ad988d2cd1f9195972bb4768f20c5f3213d0b135f3007b999676024", "manual_language": "zh", "description_zh_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a055.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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "6161d51dc66d54c8fd300944fed2bbae80efe4a532023b2e7771df5d94732330", "version": "16.16"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "c0d23bdcbad8a5daf5f0b3f68e3cda09f59d69ebf5476444ecd369309fbd52c6", "version": "16.16"}], "release": "16.16", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}}, "17": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 17.12"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\bind"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=17", "text": "\\bind"}, "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", "related": [{"url": "/wiki/tool/psql/?v=17", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.12/postgresql-17.12.tar.bz2", "label": "17.12", "major": "17", "channel": "stable", "manifest": {"major": "17", "release": "17.12", "source_url": "https://ftp.postgresql.org/pub/source/v17.12/postgresql-17.12.tar.bz2", "source_sha256": "9cf136a703d8ee2f83465c43be4e9e8e7930c82b0bfba13be7e2537be769ac55"}, "revision": "cdf1f58367ae5412a459972f45d3edc959901a849a12eaac1f08b050ba94663e", "evidence_kind": "English manual and source declarations", "source_sha256": "9cf136a703d8ee2f83465c43be4e9e8e7930c82b0bfba13be7e2537be769ac55"}, "sources": [{"url": "/docs/17/app-psql.html#APP-PSQL-META-COMMAND-BIND", "file": "app-psql.html", "label": "17.12 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "sha256": "0a15b496eec7377c3e3cdbba9c3202ea984799cde158cf8c6826d339ff454a76"}], "zh_from": "same-version-manual", "facts_zh": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 17.12"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\bind"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "description_zh_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a053.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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "summary": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "body_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a053.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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "body_sha256": "a13b5381868186967f66278d6100cf5638a4b9107ee8f9f490cb15f2637f6d4a", "content_hash": "9c3391c237657b9bfebe3584b7c662f628d31320fddcde49dd738dac28a3dfb1", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "17", "documentation_release": "17.12"}, "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=17", "text": "\\bind"}, "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=17", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "description": ["\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002"], "manual_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a053.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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "17.12"}, "description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "comparison_data": {"modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "definition": "Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.). Example: INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g This also works for query-execution commands besides \\g , such as \\gx and \\gset . This command causes the extended query protocol (see Section 53.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. (The extended query protocol is used even if the query has no parameters and this command specifies zero parameters.) This command affects only the next query executed; all subsequent queries will use the simple query protocol by default."}, "comparison_hash": "a8c1c019c20c8764583f38705ad08a718d76ba73978d812d61cb86123338159f", "manual_language": "zh", "description_zh_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\n

\n \u6b64\u547d\u4ee4\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\uff08\u53c2\u89c1\u7b2c\u00a053.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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "documentation_revision": {"inputs": [{"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "en", "sha256": "0a15b496eec7377c3e3cdbba9c3202ea984799cde158cf8c6826d339ff454a76", "version": "17.12"}, {"file": "app-psql.html", "kind": "same-version-reviewed-manual", "locale": "zh-Hans", "sha256": "72c5d1a2c80c31246970e54811e0b6ea23a7c11cefe49b9e64efbb6b84781fa2", "version": "17.12"}], "release": "17.12", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "runtime_remeasured": false}}, "18": {"lang": "zh", "facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.7"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\bind"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=18", "text": "\\bind"}, "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", "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", "file": "app-psql.html", "label": "18.7 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "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"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "description_zh_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "summary": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "body_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "body_sha256": "412afadfa2b70a13c4dd7421d71fd85ce3f8c0b9448636add9235501ae967fae", "content_hash": "ca5bbe531d5d60211244cb5dc3174d644b0f52c540ec392b7e0d439e6ecf2eb2", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "18", "documentation_release": "18.7"}, "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=18", "text": "\\bind"}, "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": ["\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002"], "manual_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "18.7"}, "description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "comparison_data": {"modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "definition": "Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.). Example: INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g This also works for query-execution commands besides \\g , such as \\gx and \\gset . 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 . (The extended query protocol is used even if the query has no parameters and this command specifies zero parameters.) This command affects only the next query executed; all subsequent queries will use the simple query protocol by default."}, "comparison_hash": "6289835b165c64d534aa75d06db8cd8fb98840ebcf240fb78f682fef2ff9a6c4", "manual_language": "zh", "description_zh_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\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 \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\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"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=19", "text": "\\bind"}, "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", "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", "file": "app-psql.html", "label": "19rc2 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "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"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "description_zh_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "summary": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "body_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "body_sha256": "1f886943b24bdd80c36307267da154aaec01791226d91a4124258a38e9e4ba0a", "content_hash": "a38d3ec77d8abcecaebe1ed51ac06db5ba438aabda159caeb838251f88e1b001", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "19", "documentation_release": "19rc2"}, "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=19", "text": "\\bind"}, "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": ["\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002"], "manual_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "19rc2"}, "description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "comparison_data": {"modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "definition": "Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.). Example: INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g This also works for query-execution commands besides \\g , such as \\gx and \\gset . 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 . (The extended query protocol is used even if the query has no parameters and this command specifies zero parameters.) This command affects only the next query executed; all subsequent queries will use the simple query protocol by default."}, "comparison_hash": "6289835b165c64d534aa75d06db8cd8fb98840ebcf240fb78f682fef2ff9a6c4", "manual_language": "zh", "description_zh_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\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"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=20", "text": "\\bind"}, "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", "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", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "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", "anchor": "APP-PSQL-META-COMMAND-BIND", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "app-psql.html", "extraction": "exact-definition", "source_hash": "98935f3e8a333e7201e42b7315bb9e09d62e0711037964568c16bd22ae183680", "fragment_sha256": "1c5984805b14531cd3ae4c0b61b5327e50a64942b40b6876253f4346d6964ade", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235", "translated_from_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "body_sha256": "346dd2ec6f48a7f9f55b5ff93014692183ebe1ee31c91db347d63380d4262ba6", "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"}], "sections": [], "center_zh": {"title": "\\bind", "locale": "zh-Hans", "source": {"key": "cmd-62-69-6e-64", "locale": "zh-Hans", "version": "20", "text_hash": "956a9bb65a4e5f141d4240e75219c14afffff9526dab16a74ea6a8ab3ba1a131", "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"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=20", "text": "\\bind"}, "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", "anchor": "APP-PSQL-META-COMMAND-BIND", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "app-psql.html", "extraction": "exact-definition", "source_hash": "98935f3e8a333e7201e42b7315bb9e09d62e0711037964568c16bd22ae183680", "fragment_sha256": "1c5984805b14531cd3ae4c0b61b5327e50a64942b40b6876253f4346d6964ade", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235", "translated_from_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "body_sha256": "346dd2ec6f48a7f9f55b5ff93014692183ebe1ee31c91db347d63380d4262ba6", "runtime_rerun": false, "authored_translation": "source-derived-identity", "source_facts_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "sections": [], "description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002 \u793a\u4f8b\uff1a INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c \\gset \u3002 \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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002", "description_zh_html": "

psql \u547d\u4ee4 \\bind [ parameter ] ...\u3002

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

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

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

"}, "summary": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002 \u793a\u4f8b\uff1a INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c \\gset \u3002 \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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002", "version": "20", "link_map": {"/zh/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-BIND": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-BIND", "/zh/docs/devel/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS": "/docs/devel/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS"}, "body_html": "

psql \u547d\u4ee4 \\bind [ parameter ] ...\u3002

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

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

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

", "body_sha256": "8e143c4b310a6a72db5b6530f174fee34b0f88745b5f0a0d99e47c1485e2c076", "content_hash": "956a9bb65a4e5f141d4240e75219c14afffff9526dab16a74ea6a8ab3ba1a131", "source_database": "center", "source_revision": "3cd0885bb4eccdbaac1a21177cc639e9031e54bd8ea6536c45224b5563354ce2"}, "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=20", "text": "\\bind"}, "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": ["\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002 \u793a\u4f8b\uff1a INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c \\gset \u3002 \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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002"], "manual_html": "", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "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[0]", "#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[3]/p[3]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[3]/p[4]"]}], "language": "zh", "original_text": {"/summary": "Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.).", "/category": "Query execution", "/versions/20/description/0": "Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.).", "/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": "78d837bfaec777e50056de0793cf73c97ac602d2693dc577efd53014c38f4fb7", "canonical_center_text_hash": "956a9bb65a4e5f141d4240e75219c14afffff9526dab16a74ea6a8ab3ba1a131"}, "description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002 \u793a\u4f8b\uff1a INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c \\gset \u3002 \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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002", "comparison_data": {"modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "definition": "Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.). Example: INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g This also works for query-execution commands besides \\g , such as \\gx and \\gset . 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 . (The extended query protocol is used even if the query has no parameters and this command specifies zero parameters.) This command affects only the next query executed; all subsequent queries will use the simple query protocol by default."}, "comparison_hash": "6289835b165c64d534aa75d06db8cd8fb98840ebcf240fb78f682fef2ff9a6c4", "manual_language": "zh", "description_zh_html": "

psql \u547d\u4ee4 \\bind [ parameter ] ...\u3002

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

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\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"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=18", "text": "\\bind"}, "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", "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", "file": "app-psql.html", "label": "18.7 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "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"}], "sections": [], "center_zh": {"locale": "zh-Hans", "payload": {"description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "description_zh_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "summary": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "body_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "body_sha256": "412afadfa2b70a13c4dd7421d71fd85ce3f8c0b9448636add9235501ae967fae", "content_hash": "ca5bbe531d5d60211244cb5dc3174d644b0f52c540ec392b7e0d439e6ecf2eb2", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "definition_version": "18", "documentation_release": "18.7"}, "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "tables_zh": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=18", "text": "\\bind"}, "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": ["\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002"], "manual_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "sections_zh": [], "localization": {"status": "same-version-reviewed-manual", "language": "zh", "source_language": "en", "source_revision": "pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552", "documentation_release": "18.7"}, "description_zh": "\u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08 $1 \u7b49\uff09\u3002", "comparison_data": {"modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "definition": "Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.). Example: INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g This also works for query-execution commands besides \\g , such as \\gx and \\gset . 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 . (The extended query protocol is used even if the query has no parameters and this command specifies zero parameters.) This command affects only the next query executed; all subsequent queries will use the simple query protocol by default."}, "comparison_hash": "6289835b165c64d534aa75d06db8cd8fb98840ebcf240fb78f682fef2ff9a6c4", "manual_language": "zh", "description_zh_html": "

\n \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

\nINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\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 \u4e3a\u4e0b\u4e00\u6b21\u67e5\u8be2\u6267\u884c\u8bbe\u7f6e\u67e5\u8be2\u53c2\u6570\uff0c\u5e76\u5c06\u6307\u5b9a\u53c2\u6570\u4f20\u7ed9\u4efb\u610f\u53c2\u6570\u5360\u4f4d\u7b26\uff08$1 \u7b49\uff09\u3002\n

\n \u793a\u4f8b\uff1a\n

INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n

\n

\n \u8fd9\u5bf9\u9664 \\g \u4e4b\u5916\u7684\u67e5\u8be2\u6267\u884c\u547d\u4ee4\u4e5f\u6709\u6548\uff0c\u4f8b\u5982 \\gx \u548c\n \\gset\u3002\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\uff08\u5373\u4f7f\u67e5\u8be2\u6ca1\u6709\u53c2\u6570\uff0c\u800c\u4e14\u6b64\u547d\u4ee4\u6307\u5b9a\u4e86\u96f6\u4e2a\u53c2\u6570\uff0c\u4e5f\u4f1a\u4f7f\u7528\u6269\u5c55\u67e5\u8be2\u534f\u8bae\u3002\uff09\u6b64\u547d\u4ee4\u53ea\u5f71\u54cd\u4e0b\u4e00\u6761\u88ab\u6267\u884c\u7684\u67e5\u8be2\uff1b\u4e4b\u540e\u7684\u6240\u6709\u67e5\u8be2\u9ed8\u8ba4\u4ecd\u4f1a\u4f7f\u7528\u7b80\u5355\u67e5\u8be2\u534f\u8bae\u3002\n

"}, "comparison": {"left": "17", "right": "18", "status": "changed", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1,5 +1,5 @@\n {\n- \"definition\": \"Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.). Example: INSERT INTO tbl1 VALUES ($1, $2) \\\\bind 'first value' 'second value' \\\\g This also works for query-execution commands besides \\\\g , such as \\\\gx and \\\\gset . This command causes the extended query protocol (see Section 53.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. (The extended query protocol is used even if the query has no parameters and this command specifies zero parameters.) This command affects only the next query executed; all subsequent queries will use the simple query protocol by default.\",\n+ \"definition\": \"Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.). Example: INSERT INTO tbl1 VALUES ($1, $2) \\\\bind 'first value' 'second value' \\\\g This also works for query-execution commands besides \\\\g , such as \\\\gx and \\\\gset . 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 . (The extended query protocol is used even if the query has no parameters and this command specifies zero parameters.) This command affects only the next query executed; all subsequent queries will use the simple query protocol by default.\",\n \"modifiers\": [],\n \"signature\": \"\\\\bind [ parameter ] ...\",\n \"spellings\": ["}}