method

indexes

v2.0.3 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::PostgreSQLAdapter

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

Related methods

Class methods (9)
create_unlogged_tables (>= v6.0.0)
database_exists? (>= v6.0.0)
datetime_type (>= v7.0.0)
dbconsole (>= v7.1.3.2)
initialize_type_map (>= v7.0.0)
native_database_types (>= v7.0.0)
new
new_client (>= v6.1.3.1)
visitor_for (>= v3.1.0)
Instance methods (196)
active?
active_threadsafe? (>= v4.1.8)
adapter_name
add_column
add_enum_value (>= v7.1.3.2)
add_oid (>= v4.1.8)
add_order_by_for_associatio... (>= v1.2.6)
add_pg_decoders (>= v5.0.0.1)
add_pg_encoders (>= v5.0.0.1)
arel_visitor (>= v5.0.0.1)
begin_db_transaction
build_insert_sql (>= v6.0.0)
build_statement_pool (>= v6.0.0)
can_perform_case_insensitiv... (>= v5.0.0.1)
cast_to_time (<= v1.2.6)
change_column
change_column_default
change_column_null
check_version (>= v6.0.0)
clear_cache! (>= v3.1.0)
client_min_messages
client_min_messages=
column_definitions (>= v1.0.0)
column_name_for_operation (>= v4.2.1)
columns
commit_db_transaction
configure_connection
connect
construct_coder (>= v5.0.0.1)
create (>= v3.0.0)
create_database (>= v2.1.0)
create_enum (>= v7.0.0)
create_savepoint (>= v2.3.8)
create_table_definition (>= v4.0.2)
current_database (>= v2.2.1)
current_schema (>= v3.2.1)
default_index_type? (>= v5.1.7)
default_sequence_name (>= v1.0.0)
default_value (<= v1.2.6)
disable_extension (>= v4.0.2)
disable_referential_integrity (>= v2.1.0)
discard! (>= v5.2.3)
disconnect!
distinct (>= v1.2.6)
drop_database (>= v2.1.0)
drop_enum (>= v7.1.3.2)
enable_extension (>= v4.0.2)
encoding (>= v2.2.1)
enum_types (>= v7.0.0)
escape_bytea (>= v1.0.0)
exec_cache (>= v3.1.0)
exec_delete (>= v3.1.0)
exec_no_cache (>= v3.1.0)
exec_query (>= v3.1.0)
exec_update (>= v3.1.0)
execute
execute_and_clear (>= v4.2.1)
explain (>= v3.2.1)
extension_available? (>= v6.0.0)
extension_enabled? (>= v4.0.2)
extensions (>= v4.0.2)
extract_default_function (>= v4.2.1)
extract_limit (>= v4.2.1)
extract_pg_identifier_from_... (>= v2.3.8)
extract_schema_and_table (>= v3.1.0)
extract_table_ref_from_inse... (>= v3.2.1)
extract_value_from_default (>= v4.2.1)
get_advisory_lock (>= v5.0.0.1)
get_database_version (>= v6.0.0)
get_oid_type (>= v4.1.8)
has_default_function? (>= v4.2.1)
index_algorithms (>= v4.0.2)
indexes
index_name_length (>= v2.3.8)
initialize_type_map (>= v4.0.2)
insert
insert_sql (>= v3.1.0)
in_transaction? (>= v5.0.0.1)
is_cached_plan_failure? (>= v5.0.0.1)
last_insert_id (>= v1.0.0)
last_insert_id_result (>= v4.0.2)
last_insert_id_value (>= v4.0.2)
load_additional_types (>= v4.2.1)
load_types_queries (>= v7.0.0)
lookup_cast_type (>= v4.2.1)
max_identifier_length (>= v5.1.7)
migration_keys (>= v4.0.2)
native_database_types (>= v1.0.0)
outside_transaction? (>= v2.3.8)
pk_and_sequence_for (>= v1.0.0)
postgresql_version
prepare_column_options (>= v4.0.2)
prepare_statement (>= v3.2.1)
primary_key (>= v2.3.8)
query (>= v2.1.0)
quote (>= v1.0.0)
quote_column_name (>= v1.0.0)
quoted_date (>= v1.2.6)
quote_string (>= v2.1.0)
quote_table_name (>= v2.3.8)
reconfigure_connection_time... (>= v7.1.3.2)
reconnect (>= v7.1.3.2)
reconnect!
recreate_database (>= v2.1.0)
release_advisory_lock (>= v5.0.0.1)
release_savepoint (>= v2.3.8)
reload_type_map (>= v4.0.2)
remove_index
remove_index! (>= v2.3.8)
rename_column
rename_enum (>= v7.1.3.2)
rename_enum_value (>= v7.1.3.2)
rename_index (>= v3.1.0)
rename_table
reset! (>= v3.1.0)
reset_pk_sequence! (>= v1.0.0)
result_as_array (>= v2.1.0)
retryable_query_error? (>= v7.1.3.2)
return_value_after_insert? (>= v7.1.3.2)
rollback_db_transaction
rollback_to_savepoint (>= v2.3.8)
schema_creation (>= v4.0.2)
schema_exists? (>= v3.2.1)
schema_search_path
schema_search_path=
select
select_raw
select_rows
serial_sequence (>= v3.1.0)
session_auth= (>= v3.1.0)
set_standard_conforming_str... (>= v2.3.8)
sql_for_insert (>= v3.1.0)
sql_key (>= v3.2.1)
substitute_at (>= v3.1.0)
supports_advisory_locks? (>= v5.0.0.1)
supports_bulk_alter? (>= v5.2.3)
supports_check_constraints? (>= v6.1.3.1)
supports_comments? (>= v5.0.0.1)
supports_common_table_expre... (>= v6.1.3.1)
supports_datetime_with_prec... (>= v5.0.0.1)
supports_ddl_transactions? (>= v2.2.1)
supports_deferrable_constra... (>= v7.0.0)
supports_disable_referentia... (>= v2.1.0)
supports_exclusion_constrai... (>= v7.1.3.2)
supports_explain? (>= v3.2.1)
supports_expression_index? (>= v5.0.0.1)
supports_extensions? (>= v4.0.2)
supports_foreign_keys? (>= v4.2.1)
supports_foreign_tables? (>= v5.2.3)
supports_identity_columns? (>= v7.1.3.2)
supports_index_include? (>= v7.1.3.2)
supports_index_sort_order? (>= v3.2.1)
supports_insert_conflict_ta... (>= v6.0.0)
supports_insert_on_conflict? (>= v6.0.0)
supports_insert_on_duplicat... (>= v6.0.0)
supports_insert_on_duplicat... (>= v6.0.0)
supports_insert_returning? (>= v6.0.0)
supports_insert_with_return... (>= v2.2.1)
supports_json? (>= v5.0.0.1)
supports_lazy_transactions? (>= v6.0.0)
supports_materialized_views? (>= v4.2.1)
supports_migrations?
supports_nulls_not_distinct? (>= v7.1.3.2)
supports_optimizer_hints? (>= v6.0.0)
supports_partial_index? (>= v4.0.2)
supports_partitioned_indexes? (>= v6.1.3.1)
supports_pgcrypto_uuid? (>= v5.1.7)
supports_primary_key? (>= v2.3.8)
supports_ranges? (>= v4.0.2)
supports_restart_db_transac... (>= v7.1.3.2)
supports_savepoints? (>= v2.3.8)
supports_standard_conformin...
supports_statement_cache? (>= v3.1.0)
supports_transaction_isolat... (>= v4.0.2)
supports_unique_constraints? (>= v7.1.3.2)
supports_validate_constraints? (>= v5.2.3)
supports_views? (>= v4.2.1)
supports_virtual_columns? (>= v7.0.0)
table_alias_length
table_definition (>= v3.1.0)
table_exists? (>= v3.0.0)
tables
transaction (>= v2.2.1)
transaction_active? (>= v2.2.1)
translate_exception (>= v3.0.0)
translate_field_type (<= v1.2.6)
truncate (>= v4.2.1)
type_cast (>= v3.1.0)
type_map (>= v4.1.8)
type_to_sql
unescape_bytea (>= v1.0.0)
update_sql
update_table_definition (>= v4.0.2)
update_typemap_for_default_... (>= v6.0.0)
use_insert_returning? (>= v4.0.2)
valid_type? (>= v4.0.2)

Icon_private_sm = private
Icon_protected_sm = protected

indexes(table_name, name = nil) public

Returns the list of all indexes for a table.

Show source

# File activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb, line 450
      def indexes(table_name, name = nil)
        result = query("SELECT i.relname, d.indisunique, a.attname\nFROM pg_class t, pg_class i, pg_index d, pg_attribute a\nWHERE i.relkind = 'i'\nAND d.indexrelid = i.oid\nAND d.indisprimary = 'f'\nAND t.oid = d.indrelid\nAND t.relname = '\#{table_name}'\nAND a.attrelid = t.oid\nAND ( d.indkey[0]=a.attnum OR d.indkey[1]=a.attnum\nOR d.indkey[2]=a.attnum OR d.indkey[3]=a.attnum\nOR d.indkey[4]=a.attnum OR d.indkey[5]=a.attnum\nOR d.indkey[6]=a.attnum OR d.indkey[7]=a.attnum\nOR d.indkey[8]=a.attnum OR d.indkey[9]=a.attnum )\nORDER BY i.relname\n", name)

        current_index = nil
        indexes = []

        result.each do |row|
          if current_index != row[0]
            indexes << IndexDefinition.new(table_name, row[0], row[1] == "t", [])
            current_index = row[0]
          end

          indexes.last.columns << row[2]
        end

        indexes
      end