Rails reset ALL Postgres sequences?

postgresql, ruby-on-rails

Solution

This is easier

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

Problem

The following works in the Rails 3 console to reset Postgres sequences: ``` ActiveRecord::Base.connection.reset_pk_sequence!('menucontrols') ActiveRecord::Base.connection.reset_pk_sequence!('statuscodes') ActiveRecord::Base.connection.reset_pk_sequence!('wostatuses') ActiveRecord::Base.connection.reset_pk_sequence!('taskstatuses') ActiveRecord::Base.connection.reset_pk_sequence!('priorities') ActiveRecord::Base.connection.reset_pk_sequence!('actcodes') ``` Is there a command that would reset ALL of them instead of having to do each one individually? Thanks for the help!

Original source