function Schema::introspectIndexSchema

Overrides Schema::introspectIndexSchema

File

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

Class

Schema

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

Namespace

Code

protected function introspectIndexSchema($table) {
    if (!$this->tableExists($table)) {
        throw new SchemaObjectDoesNotExistException("The table {$table} doesn't exist.");
    }
    $index_schema = [
        'primary key' => [],
        'unique keys' => [],
        'indexes' => [],
    ];
    // Get the schema and tablename for the table without identifier quotes.
    $full_name = str_replace('"', '', $this->connection
        ->prefixTables('{' . $table . '}'));
    $result = $this->connection
        ->query("SELECT i.relname AS index_name, a.attname AS column_name FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND a.attnum = ANY(ix.indkey) AND t.relkind = 'r' AND t.relname = :table_name ORDER BY index_name ASC, column_name ASC", [
        ':table_name' => $full_name,
    ])
        ->fetchAll();
    foreach ($result as $row) {
        if (str_ends_with($row->index_name, '_pkey')) {
            $index_schema['primary key'][] = $row->column_name;
        }
        elseif (str_ends_with($row->index_name, '_key')) {
            $index_schema['unique keys'][$row->index_name][] = $row->column_name;
        }
        elseif (str_ends_with($row->index_name, '_idx')) {
            $index_schema['indexes'][$row->index_name][] = $row->column_name;
        }
    }
    return $index_schema;
}