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.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935