We have a Symfony (v2.x, although the question applies to all Symfony versions until at least v6.x) project using Doctrine ORM (v2.x).
We managed to connect to PostgreSQL with multiple schemas in a single database.
Now when we update any entity and execute the command php app/console doctrine:schema:update it is only updating the PostgreSQL's public schema.
How can we update all schemas in PostgresSQL?
This question to all versions of Symfony, until at least 6.x line.
Probably a "too late" answer, but Doctrine will let you simply specify PostgreSQL schema in the Table annotation:
<?php
namespace App\Entity;
use Doctrine\ORM\Mapping as ORM;
#[ORM\Entity]
#[ORM\Table(schema: 'name')] // <-- whatever schema you need here.
class Entity {
//...
}
I found it to work reasonably well everywhere but automatically generated migrations. For some reason the schema tool does not insert the custom schema into index name, so down migrations involving index removal fail complaining about non-existing index.
You can create multiple entity managers in your config file. Afterwards you can update any scheme what you want. Let's assume that you have two entity manager: foo foo and bar. Then following command will update related schemas:
php app/console doctrine:schema:update --force --em=foo
php app/console doctrine:schema:update --force --em=bar
Symfony has nice documentation about it.
