Binary bytea to literal strings - Mailing list pgsql-general

Hello

Got one table:

 Column  |  Type   |                   Modifiers
---------+---------+-----------------------------------------------
 message | bytea   |

insert data like for example:

insert into zub (message) values (E'\004\065 Ciao');

is it possible to somehow get the following:

0x040x35 Ciao

Sincerely

Dragan