indexes

# File activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb, line 85
        def indexes(table_name) # :nodoc:
          scope = quoted_scope(table_name)

          result = query(            SELECT distinct i.relname, d.indisunique, d.indkey, pg_get_indexdef(d.indexrelid), t.oid,                            pg_catalog.obj_description(i.oid, 'pg_class') AS comment            FROM pg_class t            INNER JOIN pg_index d ON t.oid = d.indrelid            INNER JOIN pg_class i ON d.indexrelid = i.oid            LEFT JOIN pg_namespace n ON n.oid = i.relnamespace            WHERE i.relkind = 'i'              AND d.indisprimary = 'f'              AND t.relname = #{scope[:name]}              AND n.nspname = #{scope[:schema]}            ORDER BY i.relname, "SCHEMA")

          result.map do |row|
            index_name = row[0]
            unique = row[1]
            indkey = row[2].split(" ").map(&:to_i)
            inddef = row[3]
            oid = row[4]
            comment = row[5]

            using, expressions, where = inddef.scan(/ USING (\w+?) \((.+?)\)(?: WHERE (.+))?\z/).flatten

            orders = {}
            opclasses = {}

            if indkey.include?(0)
              columns = expressions
            else
              columns = Hash[query(                SELECT a.attnum, a.attname                FROM pg_attribute a                WHERE a.attrelid = #{oid}                AND a.attnum IN (#{indkey.join(",")}).strip_heredoc, "SCHEMA")].values_at(*indkey).compact

              # add info on sort order (only desc order is explicitly specified, asc is the default)
              # and non-default opclasses
              expressions.scan(/(?<column>\w+)"?\s?(?<opclass>\w+_ops)?\s?(?<desc>DESC)?\s?(?<nulls>NULLS (?:FIRST|LAST))?/).each do |column, opclass, desc, nulls|
                opclasses[column] = opclass.to_sym if opclass
                if nulls
                  orders[column] = [desc, nulls].compact.join(" ")
                else
                  orders[column] = :desc if desc
                end
              end
            end

            IndexDefinition.new(
              table_name,
              index_name,
              unique,
              columns,
              orders: orders,
              opclasses: opclasses,
              where: where,
              using: using.to_sym,
              comment: comment.presence
            )
          end
        end