Tag Archives: migration

PostgreSQL & Rails – зміна типу поля із string у integer

Листопад 24, 2016 by admin

Tweet

class ChangeColTypeFromStringToInteger < ActiveRecord::Migration def up change_table :table_name do |t| t.change :column_name, 'integer USING CAST(column_name AS integer)', default: 1 end end def down change_table :table_name do |t| t.change :column_name, :string end end end

1 2 3 4 5 6 7 8 9 10 11 12

class ChangeColTypeFromStringToInteger < ActiveRecord::Migration   def up     change_table :table_name do |t|       t.change :column_name, 'integer USING CAST(column_name AS integer)', default: 1     end   end   def down     change_table :table_name do |t|       t.change :column_name, :string     end   end end