Selecting schema configuration in Postgres with doctrine 2

Question

I've got a complex question, I hope you will help me.

I'm using Doctrine DBAL in my application because I would like to make it works in Postgres and Mysql.

The problem is that I want to switch over the 5 schemas that I have.

For example I would to do this thing :

What I don't want to do :

What I tried (but don't work =S):

    $connection->getConnection()->exec("SET SEARCH_PATH schema1");
    $stmt = $connection->getConnection()->executeQuery("SELECT * FROM users");

Is anyone have an idea how I can solve my problem ? I will be very thankful if you could bring me some help.

Thank you.

Freezer

Freezer freezer · Answer 1 · 2013-06-05 09:31:30Z

I found where the problem was.

I did a mistake with my code >_<

Here is the code that work :

$connection->getConnection()->exec("SET SEARCH_PATH TO schema1");
$stmt = $connection->getConnection()->executeQuery("SELECT * FROM users");

Thank you

1 Answer 1