# Direct sql statement in rails

**URL:** <https://www.ruby-forum.com/t/direct-sql-statement-in-rails/144124>\
**Category:** Rails\
**Created:** [July 25, 2008, 4:55pm UTC](https://www.ruby-forum.com/t/direct-sql-statement-in-rails/144124 "2008-07-25T16:55:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [July 25, 2008, 4:55pm UTC](https://www.ruby-forum.com/t/direct-sql-statement-in-rails/144124/1 "2008-07-25T16:55:18Z")

</div>

Hi  
I would like how can I execute a query like (Postgres sql)  
INSERT INTO oids (“filename”, “picture”)  
VALUES(‘logo.png’,lo\_import(file));

in rails…Why I am asking this is I have a table oids having fields

id | integer | not null default  
nextval(‘oids\_id\_seq’::regclass)  
filename | character varying(255) | default NULL::character varying  
picture | oid

I am trying to save an image file directly to picture field…My view  
file is

\<%= form\_tag ({:action =\> “createoid”}, {:enctype =\>  
‘multipart/form-data’}) %\>  
Picture for OID  
\<%= file\_field\_tag “logo” %\>  
\<%= submit\_tag “Save” %\>  
\<%= end\_form\_tag %\> and controller is

def createoid  
@pi = Oid.new  
@pi.filename=params[:logo].original\_filename.gsub(/[^a-zA-Z0-9.]/,  
‘\_’)  
@pi.picture=params[:logo].read  
@pi.save  
end

```
  I am getting error

```

ArgumentError: Invalid Ruby/cstring: INSERT INTO oids (“filename”,  
“picture”) VALUES(‘logo.png’, '�PNG���  
Then some nonreadable chlues like above  
And if the datatype above where bytea instead of oid no problem

Please help  
Thanks in advance  
Sijo

---

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [July 25, 2008, 7:17pm UTC](https://www.ruby-forum.com/t/direct-sql-statement-in-rails/144124/2 "2008-07-25T19:17:38Z")

</div>

Sijo Kg wrote:

> Hi  
> I would like how can I execute a query like (Postgres sql)

Take a look at the execute method on the connection object:

[http://www.railsbrain.com/api/rails-2.0.2/doc/index.html?a=M001488&name=execute](http://www.railsbrain.com/api/rails-2.0.2/doc/index.html?a=M001488&name=execute)

Peace,  
Phillip