Binary bytea to literal strings

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

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general