čt 25. 2. 2021 v 16:01 odesílatel Tom Lane napsal:
> Yambu writes:
> > Is there a reason why i'm getting text when i run the below
> > select convert_to('some_text', 'UTF8')i get back 'some_text'
>
> You must have bytea_output set to "escape".
>
yes
set bytea_output TO escape ;
postgres=#
Yambu writes:
> Is there a reason why i'm getting text when i run the below
> select convert_to('some_text', 'UTF8')i get back 'some_text'
You must have bytea_output set to "escape".
regards, tom lane
Hi
Is there a reason why i'm getting text when i run the below
select convert_to('some_text', 'UTF8')i get back 'some_text'
regards
On Mon, Feb 22, 2021 at 9:09 AM Pavel Stehule
wrote:
> Hi
>
> po 22. 2. 2021 v 7:37 odesílatel Yambu napsal:
>
>> Hello
>>
>> This sounds simple, but im not
Hi
po 22. 2. 2021 v 7:37 odesílatel Yambu napsal:
> Hello
>
> This sounds simple, but im not getting the results when i cast text to
> bytea like this first_name::bytea . Is there another way to do this?
>
You should to use convert_to function
https://www.postgresql.org/docs/current/functions-
Hello
This sounds simple, but im not getting the results when i cast text to
bytea like this first_name::bytea . Is there another way to do this?
regards
