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

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

Wiki / 协议消息

CopyOutResponse

CopyOutResponse is a backend protocol message. Identifies the message as a Start Copy Out response. This message will be followed by copy-out data.

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

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

Direction
Backend → frontend
First wire field
Byte1('H')
Field entries
5
Documented flow contexts
Simple Query; COPY Operations
direction
B
manual path
/docs/18/protocol-message-formats.html
signature
CopyOutResponse (B)

版本定义 PG 18

Byte1('H')

Identifies the message as a Start Copy Out response. This message will be followed by copy-out data.

Int32

Length of message contents in bytes, including self.

Int8

0 indicates the overall COPY format is textual (rows separated by newlines, columns separated by separator characters, etc.). 1 indicates the overall copy format is binary (similar to DataRow format). See COPY for more information.

Int16

The number of columns in the data to be copied (denoted N below).

Int16[N]

The format codes to be used for each column. Each must presently be zero (text) or one (binary). All must be zero if the overall copy format is textual.

Wire fields in documented order

PositionFormatMeaning
1Byte1('H')Identifies the message as a Start Copy Out response. This message will be followed by copy-out data.
2Int32Length of message contents in bytes, including self.
3Int80 indicates the overall COPY format is textual (rows separated by newlines, columns separated by separator characters, etc.). 1 indicates the overall copy format is binary (similar to DataRow format). See COPY for more information.
4Int16The number of columns in the data to be copied (denoted N below).
5Int16[ N ]The format codes to be used for each column. Each must presently be zero (text) or one (binary). All must be zero if the overall copy format is textual.

比较版本

完整来源事实

fields

map[description:Identifies the message as a Start Copy Out response. This message will be followed by copy-out data. format:Byte1('H')], map[description:Length of message contents in bytes, including self. format:Int32], map[description:0 indicates the overall COPY format is textual (rows separated by newlines, columns separated by separator characters, etc.). 1 indicates the overall copy format is binary (similar to DataRow format). See COPY for more information. format:Int8], map[description:The number of columns in the data to be copied (denoted N below). format:Int16], map[description:The format codes to be used for each column. Each must presently be zero (text) or one (binary). All must be zero if the overall copy format is textual. format:Int16[ N ]]

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

正文语言: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f