{"kind": "psql", "major": "18", "item": {"slug": "cmd-62-69-6e-64", "name": "\\bind", "name_zh": "", "category": "Query execution", "summary": "Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.).", "aliases": ["\\bind"], "content_hash": "01e00f641f39cb7a05984d8837eedf503e740a4f802277a3663393e727a8624a", "versions": {"16": {"facts": [{"label": "Client", "value": "psql 16.15"}, {"label": "Case-sensitive spelling", "value": "\\bind"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=16", "text": "\\bind"}, "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", "related": [{"url": "/wiki/tool/psql/?v=16", "label": "psql command-line options and complete manual"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/16/postgresql-16-A4.pdf", "bytes": 15282337, "pages": 3055, "sha256": "4bb6c1f63deedac98736d8c4c7bc0fad0ac24e85b07e21ee10411872f06afd06", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/16/postgresql-16-US.pdf", "bytes": 15164148, "pages": 3220, "sha256": "5b6b6166c89991199e144bb0ae34c17a5f29826251dbf19db1abc0df3a3e771b", "built_at": "2026-09-26"}}, "tree": "16", "index": "index.html", "major": "16", "pages": 1169, "release": "16.15", "source_url": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "revision": "3c21e58b35318021716440e67bb8bafd392b6a2b965a244d90e9e33c99e0bdef", "evidence_kind": "English manual and source declarations", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "sources": [{"url": "/docs/16/app-psql.html#APP-PSQL-META-COMMAND-BIND", "file": "app-psql.html", "label": "16.15 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "sha256": "add25957a1dfc97db721f2958782be186ab90dc0f0a47c4b720b2b6c26172493"}], "sections": [], "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "description": ["Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.)."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-BIND\"><span class=\"term\"><code class=\"literal\">\\bind</code> [ <em class=\"replaceable\"><code>parameter</code></em> ] ...</span> </dt><dd>\n<p>Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders (<code class=\"literal\">$1</code> etc.).</p>\n<p>Example:</p>\n<pre class=\"programlisting\">INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n</pre>\n<p>This also works for query-execution commands besides <code class=\"literal\">\\g</code>, such as <code class=\"literal\">\\gx</code> and <code class=\"literal\">\\gset</code>.</p>\n<p>This command causes the extended query protocol (see <a class=\"xref\" href=\"/docs/16/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" title=\"55.1.2.\u00a0Extended Query Overview\">Section\u00a055.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 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.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "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"}, "17": {"facts": [{"label": "Client", "value": "psql 17.11"}, {"label": "Case-sensitive spelling", "value": "\\bind"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=17", "text": "\\bind"}, "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", "related": [{"url": "/wiki/tool/psql/?v=17", "label": "psql command-line options and complete manual"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/17/postgresql-17-A4.pdf", "bytes": 15521293, "pages": 3099, "sha256": "1991354df0dc89e70ec39328c28988ef8b19c6a93671dab3893650b63e9f4e36", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/17/postgresql-17-US.pdf", "bytes": 15398150, "pages": 3270, "sha256": "07696c8f38abf31babf22d2db337093936e7c472d2af36d050b000c49bbcf52c", "built_at": "2026-09-26"}}, "tree": "17", "index": "index.html", "major": "17", "pages": 1143, "release": "17.11", "source_url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "revision": "58419c9b0dd42cb34c8d53695bb025a7e582edf55ccd4c5bcb1c2c7c71a37487", "evidence_kind": "English manual and source declarations", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "/docs/17/app-psql.html#APP-PSQL-META-COMMAND-BIND", "file": "app-psql.html", "label": "17.11 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "sha256": "04c77661f1c96a64e91a27313542c34aff0c7d2a94e350ed98c6f9f35700629b"}], "sections": [], "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "description": ["Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.)."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-BIND\"><span class=\"term\"><code class=\"literal\">\\bind</code> [ <em class=\"replaceable\"><code>parameter</code></em> ] ...</span> </dt><dd>\n<p>Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders (<code class=\"literal\">$1</code> etc.).</p>\n<p>Example:</p>\n<pre class=\"programlisting\">INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n</pre>\n<p>This also works for query-execution commands besides <code class=\"literal\">\\g</code>, such as <code class=\"literal\">\\gx</code> and <code class=\"literal\">\\gset</code>.</p>\n<p>This command causes the extended query protocol (see <a class=\"xref\" href=\"/docs/17/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" title=\"53.1.2.\u00a0Extended Query Overview\">Section\u00a053.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 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.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "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"}, "18": {"facts": [{"label": "Client", "value": "psql 18.6"}, {"label": "Case-sensitive spelling", "value": "\\bind"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=18", "text": "\\bind"}, "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", "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", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c"}], "sections": [], "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "description": ["Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.)."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-BIND\"><span class=\"term\"><code class=\"literal\">\\bind</code> [ <em class=\"replaceable\"><code>parameter</code></em> ] ...</span> </dt><dd>\n<p>Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders (<code class=\"literal\">$1</code> etc.).</p>\n<p>Example:</p>\n<pre class=\"programlisting\">INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n</pre>\n<p>This also works for query-execution commands besides <code class=\"literal\">\\g</code>, such as <code class=\"literal\">\\gx</code> and <code class=\"literal\">\\gset</code>.</p>\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>. (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.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "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"}, "19": {"facts": [{"label": "Client", "value": "psql 19beta4"}, {"label": "Case-sensitive spelling", "value": "\\bind"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=19", "text": "\\bind"}, "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", "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", "file": "app-psql.html", "label": "19beta4 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "sha256": "312975c12d6e4d62aeebcb5e98e7ca795c6d07ecb743b4bc64403dc42bc2a6e9"}], "sections": [], "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "description": ["Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.)."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-BIND\"><span class=\"term\"><code class=\"literal\">\\bind</code> [ <em class=\"replaceable\"><code>parameter</code></em> ] ...</span> </dt><dd>\n<p>Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders (<code class=\"literal\">$1</code> etc.).</p>\n<p>Example:</p>\n<pre class=\"programlisting\">INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n</pre>\n<p>This also works for query-execution commands besides <code class=\"literal\">\\g</code>, such as <code class=\"literal\">\\gx</code> and <code class=\"literal\">\\gset</code>.</p>\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>. (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.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "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"}, "20": {"facts": [{"label": "Client", "value": "psql 20devel"}, {"label": "Case-sensitive spelling", "value": "\\bind"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=20", "text": "\\bind"}, "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", "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", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "sha256": "6df5f6fbaff7800ae0e4a08a3116090d890a0cdcc02fddc31c1f220725905f87"}], "sections": [], "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "description": ["Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.)."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-BIND\"><span class=\"term\"><code class=\"literal\">\\bind</code> [ <em class=\"replaceable\"><code>parameter</code></em> ] ...</span> </dt><dd>\n<p>Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders (<code class=\"literal\">$1</code> etc.).</p>\n<p>Example:</p>\n<pre class=\"programlisting\">INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n</pre>\n<p>This also works for query-execution commands besides <code class=\"literal\">\\g</code>, such as <code class=\"literal\">\\gx</code> and <code class=\"literal\">\\gset</code>.</p>\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>. (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.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "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"}}}, "snapshot": {"facts": [{"label": "Client", "value": "psql 18.6"}, {"label": "Case-sensitive spelling", "value": "\\bind"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-62-69-6e-64/?v=18", "text": "\\bind"}, "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", "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", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-BIND", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c"}], "sections": [], "modifiers": [], "signature": "\\bind [ parameter ] ...", "spellings": ["\\bind"], "description": ["Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.)."], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-BIND\"><span class=\"term\"><code class=\"literal\">\\bind</code> [ <em class=\"replaceable\"><code>parameter</code></em> ] ...</span> </dt><dd>\n<p>Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders (<code class=\"literal\">$1</code> etc.).</p>\n<p>Example:</p>\n<pre class=\"programlisting\">INSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n</pre>\n<p>This also works for query-execution commands besides <code class=\"literal\">\\g</code>, such as <code class=\"literal\">\\gx</code> and <code class=\"literal\">\\gset</code>.</p>\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>. (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.</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-BIND", "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"}, "comparison": {"left": "15", "right": "16", "status": "added", "diff": "--- PostgreSQL 15\n+++ PostgreSQL 16\n@@ -1 +1,8 @@\n-Not recorded in this version\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 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.\",\n+  \"modifiers\": [],\n+  \"signature\": \"\\\\bind [ parameter ] ...\",\n+  \"spellings\": [\n+    \"\\\\bind\"\n+  ]\n+}"}}