v2.23 Preview Preview release - not for production v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions

Binary data types

Synopsis

Use the BYTEA data type to represent binary string of bytes (octets). Binary strings allow zeros (0) and non-printable bytes.

Data type Description
BYTEA Variable length binary string

Description

  • BYTEA is used to declare a binary entity.
type_specification ::= BYTEA
  • Escaped input can be used for input binary data.
SELECT E'\\001'::bytea