Re: bytea problems

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: bytea problems
Date: 2019-05-24 09:51:28
Message-ID: 0705b653-1206-d09e-087d-d047a366972c@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Lars Gustafsson 2019-05-24 10:36:41 Re: bytea problems
Previous Message Lars Gustafsson 2019-05-24 09:10:27 bytea problems