How do I create a hstore column in a Sequel migration?

Question

Sequel.migration do
  change do
    add_column :logs, :geo, HStore
  end
end

fails. Do I have to load an extension?

I suspect your answer lies in this documentation, http://sequel.jeremyevans.net/rdoc/files/doc/postgresql_rdoc.html. Specifically, look at the heading **PostgreSQL-specific Database Type Support** — Srdjan Pejic, Jan 14 '14 at 21:26
Thanks for pointing me the correct doc page, but I still can't run the migration. I tried different names like :hstore, :h_store, :pg_hstore, HStore, etc. I've loaded the :pg_store DB extension and even added sequel_pg & sequel-hstore gems to the Gemfile. Tried with json datatype and works ok, but I prefer hstore. — MegaTux, Jan 15 '14 at 14:34
Maybe it's a bug in the gem. Have you reported it to the maintainers? — Srdjan Pejic, Jan 17 '14 at 18:35
I'll look in the [G.Group](https://groups.google.com/forum/#!forum/sequel-talk), thanks. — MegaTux, Jan 20 '14 at 18:53

score 4 · Answer 1 · answered Aug 11 '16 at 20:26

I could not find this in the documentation so I asked on IRC.

jeremyevans: method_missing is used, allowing you to use any custom database types

So you can specify json, jsonb as long as the extension is enabled:

Sequel.migration do
  change do
    create_table :foo do
      primary_key :id
      jsonb :bar
    end
  end
end

To enable the extension:

Sequel.extension :pg_json

And to create a new record:

foo = Foo.new bar: Sequel.pg_jsonb({ 'baz' => 'qux' })

score 2 · Accepted Answer · answered Jan 21 '14 at 17:45

2

As the Author's gem answered me, the DB needs this additional extension before using it:

CREATE EXTENSION hstore

answered Jan 21 '14 at 17:45

MegaTux

1

BTW, the correct line is add_column :logs, :geo, :hstore # or 'hstore' – MegaTux Jan 21 '14 at 17:46

2 Answers2