Skip to content

bytea output not as hex-string #9871

@RhysSpellbinder

Description

@RhysSpellbinder

In the query tool the output of a bytea column is always "[binary data]".

I changed postgresql.conf with
bytea_output = 'hex'
or I executed
SET bytea_output = 'hex'
in the query tool
but a bytea column output is always "[binary data]"

A clear and concise description of what the bug is.

Steps to reproduce the behavior:

  1. Add in the file postgresql.conf the row: bytea_output = 'hex'
  2. reload configuration
  3. Open the query tool
  4. Execute query: SELECT myByteColumn FROM myTable
  5. The output of a bytea column is always "[binary data]".

Expected behavior:
The output of a bytea column is like the output of the query
SELECT encode(myByteColumn, 'hex') FROM myTable

Configuration:

  • OS: Windows 11
  • pgAdmin version: 9.14 (python 3.13.12)

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions