Tag Archives: schema

Best alternative to set a PostgreSQL schema using PHP PDO

To set the PostgreSQL DB connection, schema parameter is not to be included

Is this a good practice? Is there a better way to do this?

In order to specify the default schema you should set the search_path instead.

You can also set the default search_path per database user and in that case the above statement becomes redundant.