All threads / How do I set a start value for 'serial' or sequence in psql
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.,

Join the discussion

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

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

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

    logo Created with Sketch.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more. Icons by Icons8

    © 2023 GoRails, LLC. All rights reserved.