paulsturgess/reset_primary_key.md

Created February 27, 2013 19:49

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/paulsturgess/5051080.js"></script>
Save paulsturgess/5051080 to your computer and use it in GitHub Desktop.

Reset postgres primary key index using Rails

Raw

$ ActiveRecord::Base.connection.reset_pk_sequence!('table_name')

If you need the table names:

$ ActiveRecord::Base.connection.tables
=> ["accounts", "assets", ...]

Combine both of them:

        ActiveRecord::Base.connection.tables.each do |t|
          ActiveRecord::Base.connection.reset_pk_sequence!(t)
        end

This is it. Perfect answer.

2020, still great. thanks!

2020, still great. thanks!

Yep!!

2021, here for get help