Example of rails console SQL dumping and result formatting

development.rb

# dump SQL into console
require 'logger'
if ENV.include?('RAILS_ENV') && !Object.const_defined?('RAILS_DEFAULT_LOGGER') # rails 2
  Object.const_set('RAILS_DEFAULT_LOGGER', Logger.new(STDOUT)) 
else # rails 3
  ActiveRecord::Base.logger = Logger.new(STDOUT) if defined? Rails::Console
end

# enable result formatting - install gem 'hirb'
require 'hirb'
Hirb.enable