How to declare postgresql json/jsonb field with sequel?

Question

I'm stuck with that. Can't find anywhere in docs how to declare such spatial data types as inet and jsonb or json.

ruby 2.4.1, sequel 4.47

Plain ruby script with require 'sequel'.

Declaration such as

DB.create_table :requests do
  primary_key :id
  foreign_key :client_id, :clients
  foreign_key :service_id, :services
  DateTime :created_at, null: false
  DateTime :answered_at, null: false
  JsonBType :request, null: false
end

Are you refering to the postgres docs? Are you using rails? or are you trying to add a row through the psql console? — George
– George, Commented Jun 27, 2017 at 16:37
Did that work? Did you get an error? If so, what was the error? — tadman
– tadman, Commented Jun 27, 2017 at 16:54

Paul Coleman · Accepted Answer · 2017-06-27 17:15:57Z

5

You can use the alternative way of defining columns by using the column method - details can be found here. In your example this becomes:

DB.create_table :requests do
  primary_key :id
  foreign_key :client_id, :clients
  foreign_key :service_id, :services
  DateTime :created_at, null: false
  DateTime :answered_at, null: false
  column :request, :jsonb, null: false
end

answered Jun 27, 2017 at 17:15

Paul Coleman

4751 gold badge7 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How to declare postgresql json/jsonb field with sequel?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related