Re: converting text to bytea

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

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