Binary data types


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


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