Postgres Pro
Downloads
Home   >   mailing lists

Re: bytea problems - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: bytea problems
Date
Msg-id 0705b653-1206-d09e-087d-d047a366972c@a-kretschmer.de
Whole thread Raw
In response to bytea problems  (Lars Gustafsson <gumse@me.com>)
Responses Re: bytea problems  (Lars Gustafsson <gumse@me.com>)
List pgsql-novice
Tree view 

Am 24.05.19 um 11:10 schrieb Lars Gustafsson:
> Any hints? Have the way bytea data is selected changed? Should I try to select with some kind of decode function?

yeah, see bytea_output. Wild guess: it is set to 'hex'. Set it back to 
'escape'.
The default bytea output format has changed in 9.x, some years ago.


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

pgsql-novice by date:

Previous
From: Lars Gustafsson
Date:
Subject: bytea problems
Next
From: Lars Gustafsson
Date:
Subject: Re: bytea problems