Re: bytea problems

Andreas Kretschmer <[email protected]> Fri, 24 May 2019 11:51:28 +0200
Newsgroups gmane.comp.db.postgresql.novice
Message-ID <[email protected]>

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