Re: Displaying text appears as hex data

On 8 February 2011 18:45, Andreas Kretschmer <akretschmer(at)spamfence(dot)net> wrote:
> 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'

That won't help as the msg column is actually text... for some reason.
And they want to see the converted ASCII text based on the
hex-represented binary data.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935