PostgreSQL100Platform.php 980 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13
<?php

declare(strict_types=1);

namespace Doctrine\DBAL\Platforms;

use Doctrine\DBAL\Platforms\Keywords\PostgreSQL100Keywords;

/**
 * Provides the behavior, features and SQL dialect of the PostgreSQL 10.0 database platform.
 */
class PostgreSQL100Platform extends PostgreSQL94Platform
{
14
    protected function getReservedKeywordsClass(): string
15 16 17 18
    {
        return PostgreSQL100Keywords::class;
    }

Grégoire Paris's avatar
Grégoire Paris committed
19 20 21
    /**
     * {@inheritDoc}
     */
22
    public function getListSequencesSQL($database): string
23
    {
24
        return 'SELECT sequence_name AS relname,
25 26 27 28
                       sequence_schema AS schemaname,
                       minimum_value AS min_value, 
                       increment AS increment_by
                FROM   information_schema.sequences
29
                WHERE  sequence_catalog = ' . $this->quoteStringLiteral($database) . "
30 31 32 33
                AND    sequence_schema NOT LIKE 'pg\_%'
                AND    sequence_schema != 'information_schema'";
    }
}