Re: decode/encode backslash to base64

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ml(at)ft-c(dot)de, ft <ftimmer(at)ft-c(dot)de>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: decode/encode backslash to base64
Date: 2024-03-25 13:48:26
Message-ID: 2472954.1711374506@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

ft <ftimmer(at)ft-c(dot)de> writes:
> here is an example for decode and encode
> a string with backslash: 'a\'

That is not valid input syntax for bytea. See

https://www.postgresql.org/docs/current/datatype-binary.html

You've said nothing about what your actual purpose is,
so it's difficult to suggest what you should do differently.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Russell Rose | Passfield Data Systems 2024-03-25 15:43:11 Get error when calling function that returns a table
Previous Message ft 2024-03-24 21:31:08 decode/encode backslash to base64