{"Entry":{"collection":"psql","key":"cmd-62-69-6e-64-5f-6e-61-6d-65-64","name":"\\bind_named","aliases":["\\bind_named"],"metadata":{"aliases":["\\bind_named"],"category":"Query execution","content_hash":"e033e41e6008a82e820b519a67186a90fe829db19ad5c2cc1fd32eea1f251c89","derived_content_hash":"4dd9cad830af5e62c129cfe78185feb052461823ee2e66d03631fafb6f777795","documentation_refresh":{"batch":"20261113","original_source_rev":"","versions":{"18":"18.7","19":"19rc2"}},"imported_at":"2026-09-30T00:40:44.709078+08:00","name":"\\bind_named","name_zh":"","slug":"cmd-62-69-6e-64-5f-6e-61-6d-65-64","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."}},"Definition":{"Collection":"psql","Key":"cmd-62-69-6e-64-5f-6e-61-6d-65-64","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-62-69-6e-64-5f-6e-61-6d-65-64","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\bind_named","comparison_data":{"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 .","modifiers":[],"signature":"\\bind_named statement_name [ parameter ] ...","spellings":["\\bind_named"]},"comparison_hash":"d9d01fb7ba5e12d0ef1be5a90a7287c81155d001c968a0f72698117a9c9832e3","description":["\\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."],"description_zh":"\\bind_named 等同于 \\bind ，不同之处在于它把现有预备语句的名称作为第一个参数。空字符串表示未命名的预备语句。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n\u003ccode class=\"literal\"\u003e\\bind_named\u003c/code\u003e 等同于 \u003ccode class=\"literal\"\u003e\\bind\u003c/code\u003e，不同之处在于它把现有预备语句的名称作为第一个参数。空字符串表示未命名的预备语句。\n        \u003c/p\u003e\u003cp\u003e\n         示例：\n\u003c/p\u003e\u003cpre class=\"programlisting\"\u003e\nINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n\u003c/pre\u003e\u003cp\u003e\n\u003c/p\u003e\u003cp\u003e\n         此命令会使用扩展查询协议（参见\u003ca class=\"xref\" href=\"/zh/docs/18/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" title=\"54.1.2. 扩展查询概述\"\u003e第 54.1.2 节\u003c/a\u003e），不同于 \u003cspan class=\"application\"\u003epsql\u003c/span\u003e 通常使用的简单查询协议。因此，可以用它在 \u003cspan class=\"application\"\u003epsql\u003c/span\u003e 中测试扩展查询协议。\n        \u003c/p\u003e\u003c/dd\u003e","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","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"facts":[{"label":"Client","value":"psql 18.7"},{"label":"Case-sensitive spelling","value":"\\bind_named"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\bind_named"}],"localization":{"documentation_release":"18.7","language":"en","source_language":"en","source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552","status":"same-version-reviewed-manual"},"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-BIND-NAMED\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\bind_named\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003estatement_name\u003c/code\u003e\u003c/em\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003eparameter\u003c/code\u003e\u003c/em\u003e ] ... \u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n\u003ccode class=\"literal\"\u003e\\bind_named\u003c/code\u003e is equivalent to \u003ccode class=\"literal\"\u003e\\bind\u003c/code\u003e,\n         except that it takes the name of an existing prepared statement as\n         first parameter. An empty string denotes the unnamed prepared\n         statement.\n        \u003c/p\u003e\u003cp\u003e\n         Example:\n\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n\u003c/pre\u003e\u003cp\u003e\n\u003c/p\u003e\u003cp\u003e\n         This command causes the extended query protocol (see\n         \u003ca class=\"xref\" href=\"/docs/18/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" title=\"54.1.2. Extended Query Overview\"\u003eSection 54.1.2\u003c/a\u003e) to be used, unlike normal\n         \u003cspan class=\"application\"\u003epsql\u003c/span\u003e operation, which uses the simple\n         query protocol. So this command can be useful to test the extended\n         query protocol from \u003cspan class=\"application\"\u003epsql\u003c/span\u003e.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED","modifiers":[],"related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"label":"psql 命令行选项及完整手册","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sections":[],"sections_zh":[],"signature":"\\bind_named statement_name [ parameter ] ...","sources":[{"anchor":"APP-PSQL-META-COMMAND-BIND-NAMED","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED"}],"spellings":["\\bind_named"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\bind_named","url":"/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\bind_named","url":"/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=18"},"modifiers":"此语法签名未列出"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-BIND-NAMED","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-62-69-6e-64-5f-6e-61-6d-65-64","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\bind_named","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.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-BIND-NAMED\"\u003e\u003cspan\u003e\u003ccode\u003e\\bind_named\u003c/code\u003e \u003cem\u003e\u003ccode\u003estatement_name\u003c/code\u003e\u003c/em\u003e [ \u003cem\u003e\u003ccode\u003eparameter\u003c/code\u003e\u003c/em\u003e ] ... \u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n\u003ccode\u003e\\bind_named\u003c/code\u003e is equivalent to \u003ccode\u003e\\bind\u003c/code\u003e,\n         except that it takes the name of an existing prepared statement as\n         first parameter. An empty string denotes the unnamed prepared\n         statement.\n        \u003c/p\u003e\u003cp\u003e\n         Example:\n\u003c/p\u003e\u003cpre\u003eINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 \u0026#39;first value\u0026#39; \u0026#39;second value\u0026#39; \\g\n\u003c/pre\u003e\u003cp\u003e\n\u003c/p\u003e\u003cp\u003e\n         This command causes the extended query protocol (see\n         \u003ca href=\"/docs/18/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" rel=\"nofollow\"\u003eSection 54.1.2\u003c/a\u003e) to be used, unlike normal\n         \u003cspan\u003epsql\u003c/span\u003e operation, which uses the simple\n         query protocol. So this command can be useful to test the extended\n         query protocol from \u003cspan\u003epsql\u003c/span\u003e.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"ec93d72602cbdf64ec59e6f77eaf86c3cea16317623f196c40bc181a7d594d4d","Payload":{"description":["\\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."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-BIND-NAMED\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\bind_named\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003estatement_name\u003c/code\u003e\u003c/em\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003eparameter\u003c/code\u003e\u003c/em\u003e ] ... \u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n\u003ccode class=\"literal\"\u003e\\bind_named\u003c/code\u003e is equivalent to \u003ccode class=\"literal\"\u003e\\bind\u003c/code\u003e,\n         except that it takes the name of an existing prepared statement as\n         first parameter. An empty string denotes the unnamed prepared\n         statement.\n        \u003c/p\u003e\u003cp\u003e\n         Example:\n\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eINSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n\u003c/pre\u003e\u003cp\u003e\n\u003c/p\u003e\u003cp\u003e\n         This command causes the extended query protocol (see\n         \u003ca class=\"xref\" href=\"/docs/18/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" title=\"54.1.2. Extended Query Overview\"\u003eSection 54.1.2\u003c/a\u003e) to be used, unlike normal\n         \u003cspan class=\"application\"\u003epsql\u003c/span\u003e operation, which uses the simple\n         query protocol. So this command can be useful to test the extended\n         query protocol from \u003cspan class=\"application\"\u003epsql\u003c/span\u003e.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"sections":[],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\bind_named","url":"/wiki/psql/cmd-62-69-6e-64-5f-6e-61-6d-65-64/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\bind_named","Signature":"\\bind_named statement_name [ parameter ] ...","Modifiers":[]}],"SQLState":null,"Evidence":null}