mneumann / postgres-pr

A pure-Ruby (pr) library for accessing PostgreSQL databases
http://rubyforge.org/projects/postgres-pr
43 stars 13 forks source link

PostgreSQL 9+ bytea hex format unsupported #4

Open emassip opened 13 years ago

emassip commented 13 years ago

By default since PG 9, bytea column data is sent to client in 'hex' output format instead of 'escape' format.

See http://www.postgresql.org/docs/9.0/static/libpq-exec.html#LIBPQ-PQESCAPEBYTEA.

postgres-pr needs to to support this format, as the only alternative is to set the output format properties to 'escape' at DB level.