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' 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
