ARTICLE AD BOX
I have an Symfony app I'm tying to migrate from SQLServer to PostgreSQL. The database was on schema dbo on SQL Server, but on PostgreSQL it will be snb.
I changed the connection string in .env but Symfony seems to ingnore it.
The db connection works but the queries done by doctrine don't include the schema.
Here is my connection string:
"postgresql://postgres:*password*@127.0.0.1:5432/apps?serverVersion=18&charset=utf8&default_table_schema=snb"I tried this as well:
"postgresql://postgres:*password*@127.0.0.1:5432/apps?serverVersion=18&charset=utf8&schema=snb"What do I need to do?
