Forum: Ruby on Rails Escape bytea binary data in postgres SQL

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
rickthemick (Guest)
on 2005-12-21 11:38
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')

Tom M. (Guest)
on 2005-12-21 17:10
(Received via mailing list)
The ActiveRecord does this automatically, as necessary.

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

-- Tom M.
This topic is locked and can not be replied to.