method

index_name_exists?

v5.0.0.1 - 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) public

Verifies existence of an index with a given name.

# File activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb, line 155
        def index_name_exists?(table_name, index_name, default)
          table = Utils.extract_schema_qualified_name(table_name.to_s)
          index = Utils.extract_schema_qualified_name(index_name.to_s)

          select_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.identifier}'              AND t.relname = '#{table.identifier}'              AND n.nspname = #{index.schema ? "'#{index.schema}'" : 'ANY (current_schemas(false))'}, 'SCHEMA').to_i > 0
        end

index_name_exists?

Related methods