public function DatabaseSchema_pgsql::indexExists

public DatabaseSchema_pgsql::indexExists($table, $name)

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

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();
}