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 typeDescription
BYTEAVariable length binary string

Description

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