Thank you
Eric.

-s
--
Copyright 2010, all wrongs reversed.  Peter Seebach / usenet-nos...@seebs.net
http://www.seebs.net/log/ <-- lawsuits, religion, and funny pictures
http://en.wikipedia.org/wiki/Fair_Game_(Scientology) <-- get educated!

$ irb
irb(main):001:0> require 'sequel'
=> true
irb(main):003:0> DB = Sequel.connect('postgres://rthom...@127.0.0.1:5432/test')
=> #<Sequel::Postgres::Database: "postgres://rthom...@127.0.0.1:5432/test">
irb(main):006:0> DB.create_table :items do
irb(main):007:1* primary_key :id
irb(main):008:1> String :name
irb(main):009:1> Float :price
irb(main):010:1> Bytea :mybinary
irb(main):011:1> end
=> []
irb(main):013:0> items = DB[:items]
=> #<Sequel::Postgres::Dataset: "SELECT * FROM \"items\"">
irb(main):017:0> items.insert (:name => 'test', :price => rand * 100, :mybinary
      => 'djf dfjdslkf  fkfhsakfhwe sdaf hdfkhadsf jfasdfj m ^N ^M ')
(irb):17: warning: don't put space before argument parentheses
=> 1
irb(main):022:0> ds = DB[:items]
=> #<Sequel::Postgres::Dataset: "SELECT * FROM \"items\"">
irb(main):023:0> ds.each do |row|
irb(main):024:1* p row
irb(main):025:1> end
{:mybinary=>"djf dfjdslkf  fkfhsakfhwe sdaf hdfkhadsf jfasdfj m \016 \r ", :pric
      e=>45.9518099286502, :name=>"test", :id=>1}
=> #<Sequel::Postgres::Dataset: "SELECT * FROM \"items\"">
irb(main):026:0>