Set sequences with a rake task

gistfile1.rb

namespace :db do

  desc "Set Sequences to the correct value"
  task :set_sequences => [:environment] do
    tables = ActiveRecord::Base.connection.tables
    tables.reject! { |t| t =~ /schema_migrations/ }
    tables.each do |table|
      max_id = table.classify.constantize.maximum(:id) || 1
      puts "Setting id sequence for #{table} to #{max_id}"
      ActiveRecord::Base.connection.execute("select setval('#{table}_id_seq', #{max_id})")
    end
  end
end