I am creating a Sequel migration to create a new table in my PostgreSQL database. I want to define a String array column, which PostgreSQL supports.
My migration looks like this:
create_table :venues do
primary_key :id
String :reference , :null => false
String :name , :null => false
String :description , :null => false
String[] :type , :null => false
DateTime :created_at , :null => false
DateTime :updated_at , :null => false
end
How can I define something like text[]
in my migration?
You just use the column method and specify the type as a string:
column :type, "text[]"