Re: Displaying text appears as hex data - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Displaying text appears as hex data
Date
Msg-id 20110208184551.GA5043@tux
Whole thread Raw
In response to Displaying text appears as hex data  (Michael <postgresql@encambio.com>)
Responses Re: Displaying text appears as hex data
List pgsql-general
Michael <postgresql@encambio.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°

pgsql-general by date:

Previous
From: Lee Hughes
Date:
Subject: Backup/Restore Needed for Upgrade from 9.0beta4?
Next
From: Thom Brown
Date:
Subject: Re: Displaying text appears as hex data