Message-ID: <627b2e786823e1a27c3ee982c381fab627c39ff6.camel@ft-c.de>
Subject: decode/encode  backslash to base64
From: ft <ftimmer@ft-c.de>
Reply-To: ml@ft-c.de
To: pgsql-sql@lists.postgresql.org
Date: Sun, 24 Mar 2024 22:29:39 +0100
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.44.4 FreeBSD GNOME Team
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/627b2e786823e1a27c3ee982c381fab627c39ff6.camel%40ft-c.de>
Precedence: bulk

Hello,=20

here is an example for decode and encode=20
a string with backslash: 'a\'

select trim(convert_from(decode('YVw=3D', 'base64'), 'UTF8') )::text;=20
answer: 'a\'

the next query throw an error:=C2=A0
SQL Error [22P02]: ERROR: invalid input syntax for type bytea

select encode(trim(convert_from(decode('YVw=3D', 'base64'), 'UTF8')
)::text::bytea, 'base64' );

also:
select encode('a\'::text::bytea, 'base64');

What should I do?

Franz