Re: bytea problems - Mailing list pgsql-novice

From Lars Gustafsson
Subject Re: bytea problems
Date
Msg-id 20052EBA-3A72-4189-9E5D-0429974BEEE3@me.com
Whole thread Raw
In response to Re: bytea problems  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-novice
HA!! It works!! Fantastic!!

Thank you sooo much, you literally saved my day AND my weekend.

Vielen dank,
Lars.

> 24 maj 2019 kl. 11:51 skrev Andreas Kretschmer <andreas@a-kretschmer.de>:
>
>
>
> 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: Andreas Kretschmer
Date:
Subject: Re: bytea problems
Next
From: Martin Lund Askøe
Date:
Subject: Transaction locks on first insert into partitioned table partition