function Schema::findPrimaryKeyColumns

Overrides Schema::findPrimaryKeyColumns

File

core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php, line 811

Class

Schema

PostgreSQL implementation of <a href="/api/drupal/core%21lib%21Drupal%21Core%21Database%21Schema.php/class/Schema/8.9.x" title="Provides a base implementation for Database Schema." class="local">\Drupal\Core\Database\Schema</a>.

Namespace

Code

protected function findPrimaryKeyColumns($table) {
    if (!$this->tableExists($table)) {
        return FALSE;
    }
    // Fetch the 'indkey' column from 'pg_index' to figure out the order of the
    // primary key.
    // @todo Use 'array_position()' to be able to perform the ordering in SQL
    //   directly when 9.5 is the minimum  PostgreSQL version.
    $result = $this->connection
        ->query("SELECT a.attname, i.indkey FROM pg_index i JOIN pg_attribute a ON a.attrelid = i.indrelid AND a.attnum = ANY(i.indkey) WHERE i.indrelid = '{" . $table . "}'::regclass AND i.indisprimary")
        ->fetchAllKeyed();
    if (!$result) {
        return [];
    }
    $order = explode(' ', reset($result));
    $columns = array_combine($order, array_keys($result));
    ksort($columns);
    return array_values($columns);
}