On Tues., Feb 08, 2011, Thom Brown wrote: >On 8 February 2011 19:28, Andreas Kretschmer <[email protected]> wrote: >> Thom Brown <[email protected]> wrote: >>> On 8 February 2011 18:45, Andreas Kretschmer <[email protected]> >>> wrote: >>>> Michael <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
