Get views dumped into schema.rb

gistfile1.rb

module ActiveRecord
  class SchemaDumper
    def views(stream)
      # Order by reltype is important so that the views are dumped in the order
      # they are created, in case one view is dependent on others
      views = @connection.query(%Q{
        SELECT n.nspname AS schemaname,
          c.relname AS viewname,
          pg_get_viewdef(c.oid) AS definition
        FROM pg_class c
        LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
        WHERE c.relkind = 'v'::"char"
        AND n.nspname = ANY(current_schemas(false))
        ORDER by reltype ASC
      })

      views.each do |view_details|
        schema, viewname, definition = *view_details
        definition.gsub!(/\n/, ' ')
        definition.squish!
        output = <<-RUBY
  execute %Q{
    CREATE VIEW #{schema}.#{viewname}
    AS #{definition}
  }
        RUBY
        stream.puts output
      end
    end

    def trailer_with_execute(stream)
      views(stream)
      trailer_without_execute(stream)
    end
    alias_method_chain :trailer, :execute
  end
end