How to use Postgresql schemas in Doctrine 2?

Question

PostgreSQL

Good afternoon!
I understand with Doctrine + Postgresql, the question arose: how to make doctrine execute a query CREATE SCHEMA 'My_schema_name', and then correctly use the schema at work?
I tried to set the table name as schema.table_name, but the table is created in the schema publicand has the name schema`.`table.

Answer 1

I won’t speak for doctrine, but the request of the schema.table_name format should work correctly. Alternatively, you can change the current default schema before the request via SET SCHEMA 'schema_name'

Answer 2

What version of Doctrine2?

Answer 3

2.1.7