Escape bytea binary data in postgres SQL


#1

Hi!
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’)

/Rick


#2

The ActiveRecord does this automatically, as necessary.

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


– Tom M.