Binary bytea to literal strings

[Dragan Zubac <zubac@xxxxxxxxx>]

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