Re: converting text to bytea

[Yambu <hyambu@xxxxxxxxx>]

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.stehule@xxxxxxxxx> wrote:

Hi

po 22. 2. 2021 v 7:37 odesílatel Yambu <hyambu@xxxxxxxxx> 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