↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

bytea_output

Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditional PostgreSQL format). See Section 8.4 for more information. The bytea type always accepts both formats on input, regardless of this setting.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

boot val
hex
category
Client Connection Defaults / Statement Behavior
context
user
documented
true
enumvals
escape, hex
extra desc
Unknown
lang
en
max val
Unknown
metadata version
18
min val
Unknown
name
bytea_output
short desc
Sets the output format for bytea.
source
pg-settings-source-snapshot
unit
Unknown
vartype
enum

Definition PG 18

Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditional PostgreSQL format). See Section 8.4 for more information. The bytea type always accepts both formats on input, regardless of this setting.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:19aadc7629eed2f34a24c36bce899609c0e1e6c4f720912073a092ff3ea3dcea

Text language: en · wiki-repair-20261023:19aadc7629eed2f34a24c36bce899609c0e1e6c4f720912073a092ff3ea3dcea