0

I have a problem configuring symfony 3.4 with postgres. Exactly when the main scheme is not public. Symfony works and connects to the database without errors, but that's it. Application does not, because public schema does not exist. Can someone help me how to connect to a specific schema?

Improve this question
4
  • You can change the search_path for the database user alter user ... set search_path = ...; then this is independent of the application or the way you connect Commented Oct 7, 2021 at 8:22
  • @a_horse_with_no_name You can direct me to the file? This variable appears in several postgres related files in framework Commented Oct 7, 2021 at 8:56
  • Not a file. You change the "setup" of the database user through a SQL command. See the Postgres manual for details Commented Oct 7, 2021 at 8:58
  • @a_horse_with_no_name It's working. I don't know if your answer was crucial, but I did it first. It didn't work by itself. But after adding the schema name to @ORM\Table, ... yes :) Commented Oct 7, 2021 at 11:16
Related questions
2
Using symfony with postgresql
1
symfony doesn't like PostgreSQL with doctrine:build-schema
12
How to change a database to postgresql with Symfony 2.0?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.