Postgis Postgres Platform for Doctrine

PostgisPostgreSqlPlatform.php

<?php

namespace App\DBAL;

use Doctrine\DBAL\Platforms\PostgreSQLPlatform as PostgreSqlPlatformBase;

class PostgisPostgreSqlPlatform extends PostgreSqlPlatformBase
{
    public function getListNamespacesSQL()
    {
        # exclude postgis schemas
        return "SELECT schema_name AS nspname
                FROM   information_schema.schemata
                WHERE  schema_name NOT LIKE 'pg\_%'
                AND schema_name NOT LIKE 'topology'
                AND schema_name NOT LIKE 'tiger%'
                AND    schema_name != 'information_schema'";
    }

    public function getListSequencesSQL($database)
    {
        return 'SELECT sequence_name AS relname,
                       sequence_schema AS schemaname,
                       minimum_value AS min_value, 
                       increment AS increment_by
                FROM   information_schema.sequences
                WHERE  sequence_catalog = ' . $this->quoteStringLiteral($database) . "
                AND    sequence_schema NOT LIKE 'pg\_%' 
                AND sequence_schema NOT LIKE 'topology%'
                AND sequence_schema NOT LIKE 'tiger%'
                AND    sequence_schema != 'information_schema'";
    }
}

See: https://nerdpress.org/2022/10/31/doctrine-migrations-and-postgis/
and https://gist.github.com/dextervip/a2f384050748d6ee3ed7d573425e9d58