Binary data types
Attention
This page documents an earlier version. Go to the latest (v2.3) version.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