↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Protocol Messages

Parse

Parse is a frontend protocol message. Identifies the message as a Parse command.

Reading PG 18·Select a recorded version

Direction
Frontend → backend
First wire field
Byte1('P')
Field entries
6
Documented flow contexts
Extended Query
direction
F
manual path
/docs/18/protocol-message-formats.html
signature
Parse (F)

Definition PG 18

Byte1('P')

Identifies the message as a Parse command.

Int32

Length of message contents in bytes, including self.

String

The name of the destination prepared statement (an empty string selects the unnamed prepared statement).

String

The query string to be parsed.

Int16

The number of parameter data types specified (can be zero). Note that this is not an indication of the number of parameters that might appear in the query string, only the number that the frontend wants to prespecify types for.

Then, for each parameter, there is the following:

Int32

Specifies the object ID of the parameter data type. Placing a zero here is equivalent to leaving the type unspecified.

Wire fields in documented order

PositionFormatMeaning
1Byte1('P')Identifies the message as a Parse command.
2Int32Length of message contents in bytes, including self.
3StringThe name of the destination prepared statement (an empty string selects the unnamed prepared statement).
4StringThe query string to be parsed.
5Int16The number of parameter data types specified (can be zero). Note that this is not an indication of the number of parameters that might appear in the query string, only the number that the frontend wants to prespecify types for.
6Int32Specifies the object ID of the parameter data type. Placing a zero here is equivalent to leaving the type unspecified.

Compare versions

Complete source facts

fields

map[description:Identifies the message as a Parse command. format:Byte1('P')], map[description:Length of message contents in bytes, including self. format:Int32], map[description:The name of the destination prepared statement (an empty string selects the unnamed prepared statement). format:String], map[description:The query string to be parsed. format:String], map[description:The number of parameter data types specified (can be zero). Note that this is not an indication of the number of parameters that might appear in the query string, only the number that the frontend wants to prespecify types for. format:Int16], map[description:Specifies the object ID of the parameter data type. Placing a zero here is equivalent to leaving the type unspecified. format:Int32]

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f