{"kind": "psql", "major": "18", "item": {"slug": "cmd-62-69-6e-64-5f-6e-61-6d-65-64", "name": "\\bind_named", "name_zh": "", "category": "Query execution", "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.", "aliases": ["\\bind_named"], "content_hash": "e033e41e6008a82e820b519a67186a90fe829db19ad5c2cc1fd32eea1f251c89", "versions": {"18": {"facts": [{"label": "Client", "value": "psql 18.6"}, {"label": "Case-sensitive spelling", "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": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\bind_named", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql command-line options and complete manual"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND-NAMED", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c"}], "sections": [], "modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "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": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-BIND-NAMED\"><span class=\"term\"><code class=\"literal\">\\bind_named</code> <em class=\"replaceable\"><code>statement_name</code></em> [ <em class=\"replaceable\"><code>parameter</code></em> ] ...</span> </dt><dd>\n<p><code class=\"literal\">\\bind_named</code> is equivalent to <code class=\"literal\">\\bind</code>, except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement.</p>\n<p>Example:</p>\n<pre class=\"programlisting\">INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n</pre>\n<p>This command causes the extended query protocol (see <a class=\"xref\" href=\"/docs/18/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" title=\"54.1.2.\u00a0Extended Query Overview\">Section\u00a054.1.2</a>) to be used, unlike normal <span class=\"application\">psql</span> operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from <span class=\"application\">psql</span>.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "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"}, "19": {"facts": [{"label": "Client", "value": "psql 19beta4"}, {"label": "Case-sensitive spelling", "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": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\bind_named", "related": [{"url": "/wiki/tool/psql/?v=19", "label": "psql command-line options and complete manual"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/19/postgresql-19-A4.pdf", "bytes": 16064841, "pages": 3052, "sha256": "4dd099e4125c591128fc5f3ebd02178dc24781f9e5ae629f96d67c4c8547427b", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/19/postgresql-19-US.pdf", "bytes": 15974616, "pages": 3225, "sha256": "61971fa857f0956d47341a0388fa6af9ae10acf691d4b2fc009007d384b0342b", "built_at": "2026-09-26"}}, "tree": "19", "index": "index.html", "major": "19", "pages": 1155, "release": "19beta4", "source_url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "svg_assets": 5, "source_mode": "en SGML built with pinned official archive", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "revision": "1bbbbf4133d426f0e4304010688d2984c30fb67df0cc3a61b3e37eb3f6f37833", "evidence_kind": "English manual and source declarations", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "/docs/19/app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "file": "app-psql.html", "label": "19beta4 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND-NAMED", "sha256": "312975c12d6e4d62aeebcb5e98e7ca795c6d07ecb743b4bc64403dc42bc2a6e9"}], "sections": [], "modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "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": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-BIND-NAMED\"><span class=\"term\"><code class=\"literal\">\\bind_named</code> <em class=\"replaceable\"><code>statement_name</code></em> [ <em class=\"replaceable\"><code>parameter</code></em> ] ...</span> </dt><dd>\n<p><code class=\"literal\">\\bind_named</code> is equivalent to <code class=\"literal\">\\bind</code>, except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement.</p>\n<p>Example:</p>\n<pre class=\"programlisting\">INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n</pre>\n<p>This command causes the extended query protocol (see <a class=\"xref\" href=\"/docs/19/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" title=\"54.1.2.\u00a0Extended Query Overview\">Section\u00a054.1.2</a>) to be used, unlike normal <span class=\"application\">psql</span> operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from <span class=\"application\">psql</span>.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "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"}, "20": {"facts": [{"label": "Client", "value": "psql 20devel"}, {"label": "Case-sensitive spelling", "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": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\bind_named", "related": [{"url": "/wiki/tool/psql/?v=20", "label": "psql command-line options and complete manual"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/20/postgresql-20-A4.pdf", "bytes": 16030631, "pages": 3052, "sha256": "bd5d82c0ce38fc18f92a0447818a91a193a261776bca1c37564bf9a683e177d0", "built_at": "2026-09-28"}, "US": {"url": "/files/documentation/pdf/20/postgresql-20-US.pdf", "bytes": 15936613, "pages": 3223, "sha256": "d97d9e0db479a02f4234b175f50fcad70c3661619afc8d6df9b9437882e3c299", "built_at": "2026-09-28"}}, "tree": "0", "index": "index.html", "major": "20", "pages": 1156, "release": "20devel", "source_url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "svg_assets": 6, "source_mode": "en SGML built with pinned official archive", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_snapshot_utc": "26-Sep-2026 20:22"}, "revision": "2eba5e0fd4c3bffb2803247b6cd537878e9d6ee5a6dfbe3c50ece8b421b80918", "evidence_kind": "English manual and source declarations", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "/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": "6df5f6fbaff7800ae0e4a08a3116090d890a0cdcc02fddc31c1f220725905f87"}], "sections": [], "modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "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": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-BIND-NAMED\"><span class=\"term\"><code class=\"literal\">\\bind_named</code> <em class=\"replaceable\"><code>statement_name</code></em> [ <em class=\"replaceable\"><code>parameter</code></em> ] ...</span> </dt><dd>\n<p><code class=\"literal\">\\bind_named</code> is equivalent to <code class=\"literal\">\\bind</code>, except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement.</p>\n<p>Example:</p>\n<pre class=\"programlisting\">INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n</pre>\n<p>This command causes the extended query protocol (see <a class=\"xref\" href=\"/docs/devel/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" title=\"54.1.2.\u00a0Extended Query Overview\">Section\u00a054.1.2</a>) to be used, unlike normal <span class=\"application\">psql</span> operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from <span class=\"application\">psql</span>.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "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"}}}, "snapshot": {"facts": [{"label": "Client", "value": "psql 18.6"}, {"label": "Case-sensitive spelling", "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": "None listed in this signature"}], "title": "Spellings in this manual definition", "columns": [{"key": "command", "label": "Command"}, {"key": "modifiers", "label": "Documented suffix modifiers"}]}], "command": "\\bind_named", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql command-line options and complete manual"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND-NAMED", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c"}], "sections": [], "modifiers": [], "signature": "\\bind_named statement_name [ parameter ] ...", "spellings": ["\\bind_named"], "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": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-BIND-NAMED\"><span class=\"term\"><code class=\"literal\">\\bind_named</code> <em class=\"replaceable\"><code>statement_name</code></em> [ <em class=\"replaceable\"><code>parameter</code></em> ] ...</span> </dt><dd>\n<p><code class=\"literal\">\\bind_named</code> is equivalent to <code class=\"literal\">\\bind</code>, except that it takes the name of an existing prepared statement as first parameter. An empty string denotes the unnamed prepared statement.</p>\n<p>Example:</p>\n<pre class=\"programlisting\">INSERT INTO tbls1 VALUES ($1, $2) \\parse stmt1\n\\bind_named stmt1 'first value' 'second value' \\g\n</pre>\n<p>This command causes the extended query protocol (see <a class=\"xref\" href=\"/docs/18/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" title=\"54.1.2.\u00a0Extended Query Overview\">Section\u00a054.1.2</a>) to be used, unlike normal <span class=\"application\">psql</span> operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from <span class=\"application\">psql</span>.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND-NAMED", "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"}, "comparison": {"left": "17", "right": "18", "status": "added", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1 +1,8 @@\n-Not recorded in this version\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+}"}}