devise + postgres. case-insensitive login.

gistfile1.rb

### User model ###
class User < ActiveRecord::Base
    
    before_save :lower_email
    def lower_email
      self.email = email.downcase
    end

end

### Custom sessions controller ###
class SessionsController < Devise::SessionsController

  def create
    params[:user][:email].downcase!
    super
  end

end

### Modify existing emails in database ###
UPDATE "users" SET "email" = LOWER("email");

Thanks. This was handy.