Scope Configuration doesn't work with Postgres

[Manny651]

Scope Configuration does not seem to work at all with PostgreSQL.

• If "database" is specified in the sub configuration (config.json), it generates an invalid statement:

ERROR: syntax error at or near "`" at character 20. STATEMENT: SET search_path TO `databaseName`

• If a "database" is not specified, the process freezes.

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/74309620-scope-configuration-doesn-t-work-with-postgres?utm_campaign=plugin&utm_content=tracker%2F14258523&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F14258523&utm_medium=issues&utm_source=github).

[jwdinker]

is it hanging when it loads the migration subfolder?

[INFO] loaded extra config for migration subfolder: "hm_private/config.json"

[wzrdtales]

postgres is a lot different than other databases. can you post your config, then I can have a look and verify. What i think the issue is, that you specified database instead of schema in the config.

[Manny651]

I just looked at the code, and I see several issues in the switchDatabase function:

• Backticks are used as escape characters (instead of quotation marks)
• If the options object does not have a database field, the callback is never called
• It uses the database option to set the search path (instead of the schema).