method

index_name_exists?

v5.1.7 - Show latest stable - 0 notes - Class: SchemaStatements

1.0.0
1.1.6
1.2.6
2.0.3
2.1.0
2.2.1
2.3.8
3.0.0
3.0.9
3.1.0
3.2.1
3.2.8
3.2.13
4.0.2
4.1.8
4.2.1 (0)
4.2.7 (0)
4.2.9 (0)
5.0.0.1 (38)
5.1.7 (0)
5.2.3 (0)
6.0.0 (0)
6.1.3.1 (0)
6.1.7.7 (0)
7.0.0 (0)
7.1.3.2 (0)
7.1.3.4 (0)
What's this?

index_name_exists?(table_name, index_name, default = nil) public

Verifies existence of an index with a given name.

# File activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb, line 67
        def index_name_exists?(table_name, index_name, default = nil)
          unless default.nil?
            ActiveSupport::Deprecation.warn(              Passing default to #index_name_exists? is deprecated without replacement..squish)
          end
          table = quoted_scope(table_name)
          index = quoted_scope(index_name)

          query_value(            SELECT COUNT(*)            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 i.relname = #{index[:name]}              AND t.relname = #{table[:name]}              AND n.nspname = #{index[:schema]}, "SCHEMA").to_i > 0
        end

index_name_exists?

Related methods