↑↓ select ↵ open ⌫ change scope Open full search

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

Wiki / Protocol Messages / Frontend messages

Execute

Execute is a frontend protocol message. Identifies the message as an Execute command.

Reading PostgreSQL 18.6.

Description

Execute is a frontend protocol message. Identifies the message as an Execute command.

Direction
Frontend → backend
First wire field
Byte1('E')
Field entries
4
Documented flow contexts
Extended Query; Function Call; COPY Operations

Usage

Execute (F)

Framing and repetition

The complete definition below retains repetition, counts and conditional fields. A numbered table row is a documented field definition, not a fixed byte offset. Integer encodings and flow rules follow the same-version protocol chapter.

Wire fields in documented order

PositionFormatMeaning
1Byte1('E')Identifies the message as an Execute command.
2Int32Length of message contents in bytes, including self.
3StringThe name of the portal to execute (an empty string selects the unnamed portal).
4Int32Maximum number of rows to return, if portal contains a query that returns rows (ignored otherwise). Zero denotes “ no limit ” .

Manual definition

Byte1('E')

Identifies the message as an Execute command.

Int32

Length of message contents in bytes, including self.

String

The name of the portal to execute (an empty string selects the unnamed portal).

Int32

Maximum number of rows to return, if portal contains a query that returns rows (ignored otherwise). Zero denotes “no limit”.

Related entries

Documentation and source

Source build
Version
18.6
Build
https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
Source fingerprint
555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Compare versions

PostgreSQL 17 → 18: unchanged.

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

Export JSON · Back to Protocol Messages · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.