On 8 February 2011 19:28, Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> wrote: > Thom Brown <thom@xxxxxxxxx> wrote: > >> On 8 February 2011 18:45, Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> wrote: >> > Michael <postgresql@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
