↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / psql 命令

\bind

Sets query parameters for the next query execution, with the specified parameters passed for any parameter placeholders ( $1 etc.).

当前阅读 PG 18·选择有来源记录的版本

此版本暂无所选语言的定义,以下显示原始英文内容。

Client
psql 18.6
Case-sensitive spelling
\bind
command
\bind
manual path
app-psql.html#APP-PSQL-META-COMMAND-BIND
modifiers
未知
signature
\bind [ parameter ] ...
spellings
\bind

版本定义 PG 18

\bind [ parameter ] ...

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.

精确保留大小写的命令写法

  • \bind

Spellings in this manual definition

CommandDocumented suffix modifiers
\bindNone listed in this signature

比较版本

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8

正文语言: en · ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8