decode/encode backslash to base64 - Mailing list pgsql-sql

From ft
Subject decode/encode backslash to base64
Date
Msg-id 0afcf065cd34cc84655864da20e3589e634b83c0.camel@ft-c.de
Whole thread Raw
List pgsql-sql
Hello,

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

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

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

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

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

What should I do?

Franz




pgsql-sql by date:

Previous
From: ft
Date:
Subject: decode/encode backslash to base64
Next
From: Tom Lane
Date:
Subject: Re: decode/encode backslash to base64