How to see the sql statements for rails commands

Just type the following command in your rails console to see the sql output of your rails commands


ActiveRecord::Base.logger = Logger.new(STDOUT)

NOTE: You will probably have to do this for every session. To avoid that, add the following to your ~/.irbrc file


require 'rubygems'

if ENV.include?('RAILS_ENV') && ENV["RAILS_ENV"] == 'development'
ActiveRecord::Base.logger = Logger.new(STDOUT)
end