Sets the output format for values of type bytea.
At a glance
| Property | Value |
|---|---|
| Parameter | bytea_output |
| Category | Client Connection Defaults |
| Default | hex |
| Value type | enum |
| Change scope | Per-session (SET) |
| Available in | PostgreSQL 12, 13, 14, 15, 16, 17, 18, 19 (added in 12) |
What it does
Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditional PostgreSQL format). See datatype_binary for more information. The bytea type always accepts both formats on input, regardless of this setting.
(Description quoted from the official PostgreSQL documentation.)
How to apply a change
Can be set per session with SET, per role/database with ALTER ROLE/DATABASE ... SET, or globally in postgresql.conf.
Inspect the current value and source with SHOW bytea_output; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'bytea_output';.
Tuning guidance
This sets a session default (locale, formatting, search path or transaction behaviour) rather than a performance knob. Set it per role or database with ALTER ROLE/DATABASE ... SET so the right default follows the right workload, and prefer setting it explicitly in the application for behaviour the query results depend on.