Thom Brown <thom@xxxxxxxxx> wrote: > 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. 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° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
