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
BYTEAis used to declare a binary entity.
type_specification ::= BYTEA
- Escaped input can be used for input binary data.
SELECT E'\\001'::bytea