Monkey patch to make postgres views work with rails 3.x

application.rb

class ApplicationController < ActionController::Base
  require 'postgresql_view_monkey'
end

postgresql_view_monkey.rb

module ActiveRecord
  module ConnectionAdapters
    class PostgreSQLAdapter
      def table_exists?(name)
        name = name.to_s
        table, schema = name.split('.', 2).reverse # avoid futzing with no schema case

        if name =~ /^"/ # Handle quoted table names
          table  = name.gsub(/^"|"$/,'')
          schema = nil
        end

        not query(<<-SQL).blank?
          SELECT TRUE FROM pg_tables, pg_views
          WHERE (pg_tables.tablename = '#{table}'
                 OR pg_views.viewname = '#{table}')
          #{schema ? "AND schemaname = '#{schema}'" : ''} LIMIT 1
        SQL
      end
    end
  end
end

Unlike most monkeys, this one can't be used in an initializer, it needs to be loaded later.