How to specify :primary_key starting value in rails schema migration?

Question

I have a postgres table and a schema that creates a primary id (sequence) that auto increments by 1. How do I specify the starting value? I am happy with the increment value. Here is my schema migration:

create_table "ServiceProvider", {:primary_key => :ID} do |t|
  t.integer "ID",                       :null => false
end

Thank you

Answer 1

Use this option :

create_table "ServiceProvider",:options => "AUTO_INCREMENT = 1234" do |t|
  ...
end

But be carefull, this wouldn't work with ALL database management systems. I know this should work with MySQL but you might want to double check for postgres.