{"Entry":{"collection":"psql","key":"cmd-62-69-6e-64","name":"\\bind","aliases":["\\bind"],"metadata":{"aliases":["\\bind"],"category":"Query execution","content_hash":"01e00f641f39cb7a05984d8837eedf503e740a4f802277a3663393e727a8624a","imported_at":"2026-09-30T00:40:44.706346+08:00","name":"\\bind","name_zh":"","slug":"cmd-62-69-6e-64","summary":"Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.)."}},"Definition":{"Collection":"psql","Key":"cmd-62-69-6e-64","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-62-69-6e-64","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","Facts":{"command":"\\bind","comparison_data":{"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.","modifiers":[],"signature":"\\bind [ parameter ] ...","spellings":["\\bind"]},"comparison_hash":"6289835b165c64d534aa75d06db8cd8fb98840ebcf240fb78f682fef2ff9a6c4","description":["Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.)."],"facts":[{"label":"Client","value":"psql 18.6"},{"label":"Case-sensitive spelling","value":"\\bind"}],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-BIND\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\bind\u003c/code\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003eparameter\u003c/code\u003e\u003c/em\u003e ] ...\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eSets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders (\u003ccode class=\"literal\"\u003e$1\u003c/code\u003e etc.).\u003c/p\u003e\n\u003cp\u003eExample:\u003c/p\u003e\n\u003cpre class=\"programlisting\"\u003eINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n\u003c/pre\u003e\n\u003cp\u003eThis also works for query-execution commands besides \u003ccode class=\"literal\"\u003e\\g\u003c/code\u003e, such as \u003ccode class=\"literal\"\u003e\\gx\u003c/code\u003e and \u003ccode class=\"literal\"\u003e\\gset\u003c/code\u003e.\u003c/p\u003e\n\u003cp\u003eThis command causes the extended query protocol (see \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 \u003cspan class=\"application\"\u003epsql\u003c/span\u003e operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from \u003cspan class=\"application\"\u003epsql\u003c/span\u003e. (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.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-BIND","modifiers":[],"related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[],"signature":"\\bind [ parameter ] ...","sources":[{"anchor":"APP-PSQL-META-COMMAND-BIND","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-BIND"}],"spellings":["\\bind"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\bind","url":"/wiki/psql/cmd-62-69-6e-64/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-BIND","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-BIND","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-BIND"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-62-69-6e-64","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\bind","Summary":"Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.).","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-BIND\"\u003e\u003cspan\u003e\u003ccode\u003e\\bind\u003c/code\u003e [ \u003cem\u003e\u003ccode\u003eparameter\u003c/code\u003e\u003c/em\u003e ] ...\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eSets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders (\u003ccode\u003e$1\u003c/code\u003e etc.).\u003c/p\u003e\n\u003cp\u003eExample:\u003c/p\u003e\n\u003cpre\u003eINSERT INTO tbl1 VALUES ($1, $2) \\bind \u0026#39;first value\u0026#39; \u0026#39;second value\u0026#39; \\g\n\u003c/pre\u003e\n\u003cp\u003eThis also works for query-execution commands besides \u003ccode\u003e\\g\u003c/code\u003e, such as \u003ccode\u003e\\gx\u003c/code\u003e and \u003ccode\u003e\\gset\u003c/code\u003e.\u003c/p\u003e\n\u003cp\u003eThis command causes the extended query protocol (see \u003ca href=\"/docs/18/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS\" rel=\"nofollow\"\u003eSection 54.1.2\u003c/a\u003e) to be used, unlike normal \u003cspan\u003epsql\u003c/span\u003e operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from \u003cspan\u003epsql\u003c/span\u003e. (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.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","ContentHash":"66cd205feac64183757df182b6f8ee0ecea67abccb32f83a77ad3ba688622ffc","Payload":{"description":["Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.)."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-BIND\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\bind\u003c/code\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003eparameter\u003c/code\u003e\u003c/em\u003e ] ...\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eSets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders (\u003ccode class=\"literal\"\u003e$1\u003c/code\u003e etc.).\u003c/p\u003e\n\u003cp\u003eExample:\u003c/p\u003e\n\u003cpre class=\"programlisting\"\u003eINSERT INTO tbl1 VALUES ($1, $2) \\bind 'first value' 'second value' \\g\n\u003c/pre\u003e\n\u003cp\u003eThis also works for query-execution commands besides \u003ccode class=\"literal\"\u003e\\g\u003c/code\u003e, such as \u003ccode class=\"literal\"\u003e\\gx\u003c/code\u003e and \u003ccode class=\"literal\"\u003e\\gset\u003c/code\u003e.\u003c/p\u003e\n\u003cp\u003eThis command causes the extended query protocol (see \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 \u003cspan class=\"application\"\u003epsql\u003c/span\u003e operation, which uses the simple query protocol. So this command can be useful to test the extended query protocol from \u003cspan class=\"application\"\u003epsql\u003c/span\u003e. (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.\u003c/p\u003e\n\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","url":"/wiki/psql/cmd-62-69-6e-64/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\bind","Signature":"\\bind [ parameter ] ...","Modifiers":[]}],"SQLState":null,"Evidence":null}