Doctrine PostgreSQL Default Schema Fix For Symfony

FixPostgreSQLDefaultSchemaListener.php

<?php

declare(strict_types=1);

namespace App\Doctrine\EventListener;

use Doctrine\DBAL\Schema\PostgreSQLSchemaManager;
use Doctrine\ORM\Tools\Event\GenerateSchemaEventArgs;

final class FixPostgreSQLDefaultSchemaListener
{
    /**
     * @throws \Doctrine\DBAL\Exception
     */
    public function postGenerateSchema(GenerateSchemaEventArgs $args): void
    {
        $schemaManager = $args
            ->getEntityManager()
            ->getConnection()
            ->createSchemaManager();

        if (!$schemaManager instanceof PostgreSQLSchemaManager) {
            return;
        }

        $schema = $args->getSchema();

        foreach ($schemaManager->listSchemaNames() as $namespace) {
            if (!$schema->hasNamespace($namespace)) {
                $schema->createNamespace($namespace);
            }
        }
    }
}

services.php

<?php

declare(strict_types=1);

use App\Doctrine\EventListener\FixPostgreSQLDefaultSchemaListener;
use Doctrine\ORM\Tools\ToolEvents;
use Symfony\Component\DependencyInjection\Loader\Configurator\ContainerConfigurator;

return static function (ContainerConfigurator $configurator): void {
    $services = $configurator->services();

    $services
        ->set(FixPostgreSQLDefaultSchemaListener::class)
            ->tag('doctrine.event_listener', ['event' => ToolEvents::postGenerateSchema]);
};

services.yaml

services:
    App\Doctrine\EventListener\FixPostgreSQLDefaultSchemaListener:
        tags:
            - { name: doctrine.event_listener, event: postGenerateSchema }

Im not proud of this - but for anyone wanting to not break schema tool operations doctrine:schema:create you can add a guard statement to the event listener limiting the fix to only be applied when running doctrine:migrations:diff

final class FixPostgreSQLDefaultSchemaListener
{
    /**
     * @throws \Doctrine\DBAL\Exception
     */
    public function postGenerateSchema(GenerateSchemaEventArgs $args): void
    {
        // Only apply this fix when using the doctrine:migrations:diff command
        if (
            !isset($_SERVER['argv'])
            || !is_array($_SERVER['argv'])
            || !in_array('doctrine:migrations:diff', $_SERVER['argv'], true)
        ) {
            return;
        }