Checks if an index exists in the given table.

Parameters

$table: The name of the table in drupal (no prefixing).

$name: The name of the index in drupal (no prefixing).

Return value

bool TRUE if the given index exists, otherwise FALSE.

Overrides Schema::indexExists

2 calls to Schema::indexExists()

Schema::addIndex in core/modules/pgsql/src/Driver/Database/pgsql/Schema.php

Add an index.

Schema::dropIndex in core/modules/pgsql/src/Driver/Database/pgsql/Schema.php

Drop an index.

File

core/modules/pgsql/src/Driver/Database/pgsql/Schema.php, line 723

Class

Schema

PostgreSQL implementation of \Drupal\Core\Database\Schema.

Namespace

Drupal\pgsql\Driver\Database\pgsql

Code

public function indexExists($table, $name) {
  // Details https://www.postgresql.org/docs/12/view-pg-indexes.html
  $index_name = $this->ensureIdentifiersLength($table, $name, 'idx');
  // Remove leading and trailing quotes because the index name is in a WHERE
  // clause and not used as an identifier.
  $index_name = str_replace('"', '', $index_name);
  $sql_params = [
    ':schema' => $this->defaultSchema,
    ':table' => $this->connection
      ->getPrefix() . $table,
    ':index' => $index_name,
  ];
  return (bool) $this->connection
    ->query("SELECT 1 FROM pg_indexes WHERE schemaname = :schema AND tablename = :table AND indexname = :index", $sql_params)
    ->fetchField();
}

---