public function DatabaseSchema_pgsql::indexExists in Drupal 7

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

TRUE if the given index exists, otherwise FALSE.

Overrides DatabaseSchema::indexExists

2 calls to DatabaseSchema_pgsql::indexExists()

DatabaseSchema_pgsql::addIndex in includes/database/pgsql/schema.inc

Add an index.

DatabaseSchema_pgsql::dropIndex in includes/database/pgsql/schema.inc

Drop an index.

File

includes/database/pgsql/schema.inc, line 417

Database schema code for PostgreSQL database servers.

Class

DatabaseSchema_pgsql

Code

public function indexExists($table, $name) {

  // Details http://www.postgresql.org/docs/8.3/interactive/view-pg-indexes.html
  $index_name = '{' . $table . '}_' . $name . '_idx';
  return (bool) $this->connection
    ->query("SELECT 1 FROM pg_indexes WHERE indexname = '{$index_name}'")
    ->fetchField();
}