Re: converting text to bytea

[Yambu]

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 <pavel.steh...@gmail.com>
wrote:

> Hi
>
> po 22. 2. 2021 v 7:37 odesílatel Yambu <hya...@gmail.com> 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-binarystring.html#FUNCTIONS-BINARYSTRING-CONVERSIONS
>
> Regards
>
> Pavel
>
>
>> regards
>>
>