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 81,149+ developers who get early access to new tutorials, screencasts, articles, and more.

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

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

    © 2024 GoRails, LLC. All rights reserved.