Escape bytea binary data in postgres SQL

I want to escape binary data correctly either manually or using some
pre-defined function that does this for me!

I have found on the web: PGconn.escape_bytea but I only get “undefined
method”. Any ideas, what is the correct way of doing this my self?

I’m using Rails (WEBrick) under Windows XP with postgre-pr 0.4.0

I have tried:

s_buffer = s_buffer.gsub(/[’]/, ‘\047’)
s_buffer = s_buffer.gsub(/[\]/, ‘\134’)
s_buffer = s_buffer.gsub(/[\0]/, ‘\000’)


The ActiveRecord does this automatically, as necessary.

Or, I’ve been very lucky storing uploaded photos in a
BYTEA in PostgreSQL.

– Tom M.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs