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

Learning Ruby on Rails? Join our newsletter.

We won't send you spam. Unsubscribe at any time.