Re: Displaying text appears as hex data

Michael <postgresql(at)encambio(dot)com> wrote:

>
> Hello list,
>
> I'm trying to view text data stored by OpenSIPS 1.6.4 (the latest)
> as BLOB and PostgreSQL is displaying it in hex format like so:
>
> $ TERM=vt100 /pfx/bin/psql opensips opensips
> psql (9.0.2)
> Type "help" for help.
>
> opensips=> select * from sip_trace;
> id | time_stamp | callid | traced_user | msg | method | ...
> 1234 | 2011-02-03 | ... | | \x494e56495445207369703a...

set:

bytea_output = 'escape'

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°