New Discussion

Notifications

You’re not receiving notifications from this thread.

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

0
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.,

Join the discussion
Create an account Log in

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

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

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