Reset postgres primary key index using Rails

reset_primary_key.md

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

If you need the table names:

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

If you need to reset for all tables:

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

 $ all_tables.each do |table|
 $   ActiveRecord::Base.connection.reset_pk_sequence!(table)
 $ end