Re: converting text to bytea

[Pavel Stehule]

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
>