Use PostgreSQL JSON column type with Rails 3

Question

The following migration in Rails 3 works:

class CreateUserActions < ActiveRecord::Migration
  def up
    create_table :user_actions do |t|
      t.datetime :time
      t.integer  :user_id
      t.text     :action
      t.column   :details, :json
      t.timestamps
    end
  end

  def down
    drop_table 'user_actions'
  end
end

...but schema.rb is now incomplete reporting

# Could not dump table "user_actions" because of following StandardError
#   Unknown type 'json' for column 'details'

So rake db:reset will fail to create the user_actions table.

crizCraig · Accepted Answer · 2013-12-19 03:03:25Z

8

From: https://github.com/diogob/activerecord-postgres-hstore just set the following in application.rb:

config.active_record.schema_format = :sql

Now structure.sql will be used instead of schema.rb to create the database from scratch with rake db:reset or rake db:prepare and will be specific to PostGres.

answered Dec 19, 2013 at 3:03

crizCraig

8,9576 gold badges59 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tyler Over a year ago

Nice! I didn't even know this was possible.

Collectives™ on Stack Overflow

Use PostgreSQL JSON column type with Rails 3

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related