Set/Change Rails id auto increment value

Question

Is there a way for me to set the increment value of id in Rails? Instead of +1, to be +10 (or some other function I specify).

In MySQL there is an option @@auto_increment_increment. Is there a way to set in Rails through ActiveRecord? I am working with both Postgres.

See this - http://stackoverflow.com/questions/5440401/change-autoincrement-values-in-migration-postgresql-and-sqlite3 — Anand, Jan 12 '12 at 12:45

score 1 · Accepted Answer · answered Jan 12 '12 at 10:37

There is a example where they hardcode some sql

class SomeMigration < ActiveRecord::Migration

    def up
      execute <<-SQL
            ALTER TABLE xxx
      SQL
    end

end

1 Answers1