Ask A Question

Notifications

You’re not receiving notifications from this thread.

How do I set a start value for 'serial' or sequence in psql

Squealer182 asked in Ruby

Hi everyone,

I have a migration like this:

def change
    add_column :orders, :order_number, :serial
end

and when I create a new record in the database I get 1,2,3 etc.,
What I need is to set a start value like 1000 and auto increment to 1001, 1002,.. etc.,

Reply
Join the discussion
Create an account Log in

Want to stay up-to-date with Ruby on Rails?

Join 82,329+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.