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 20110208204811.GA9764@tux
Whole thread Raw
In response to Re: Displaying text appears as hex data  (Thom Brown <thom@linux.com>)
List pgsql-general
Thom Brown <thom@linux.com> wrote:

> On 8 February 2011 19:28, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
> > Thom Brown <thom@linux.com> wrote:
> >
> >> On 8 February 2011 18:45, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
> >> > 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:
> >        ^^^^
> >
> >> >
> >> > set:
> >> >
> >> > bytea_output = 'escape'
> >>
> >> That won't help as the msg column is actually text... for some reason.
> >
> > Are you sure? I know that problem from DRUPAL with 9.0.
>
> I asked Michael to confirm the column type of msg and it turned out to
> be text.  No mention of the lo contrib module, so I guess that may
> possibly come into play, but I wouldn't know about that.

Okay, you are right, i haven't read the other sub-thread, sorry.


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: Adrian Klaver
Date:
Subject: Re: Permission denied error - best way to fix?
Next
From: Peter Geoghegan
Date:
Subject: Re: plperl.dll on windows with postgresql 9.0.3