On Tues., Feb 08, 2011, Thom Brown wrote: >On 8 February 2011 19:28, Andreas Kretschmer <akretsch...@spamfence.net> wrote: >> Thom Brown <t...@linux.com> wrote: >>> On 8 February 2011 18:45, Andreas Kretschmer <akretsch...@spamfence.net> >>> wrote: >>>> Michael <postgre...@encambio.com> wrote: >>>>> 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. > By the way if the data is indeed properly stored as text in the database, why isn't it printed as text when using a plain SELECT? The text data is printed as binary hex instead, what?!
...but the conversion works of course. Regards, Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general