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: >> >> $ TERM=vt100 /pfx/bin/psql opensips opensips >> psql (9.0.2) >> Type "help" for help. >> >> opensips=> select * from sip_trace; >> id | time_stamp | callid | traced_user | msg | method | ... >> 1234 | 2011-02-03 | ... | | \x494e56495445207369703a... > > set: > > bytea_output = 'escape' That won't help as the msg column is actually text... for some reason. And they want to see the converted ASCII text based on the hex-represented binary data. -- 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
