Multiple schema support or tricks

[legithubdeaymeric]

I'm submitting a...

• Bug report
• Feature request
• Question

Current behavior

Good morning

Quick question.
Is there a way to manipulate tables other than the default schema.

for example I would like to create a table in several schemas

db.createTable('OTHER_SCHEMA.table', { id: { type: 'int', primaryKey: true }, name: 'string' });

Thanks !

Environment

db-migrate version: 0.11.13
db-migrate-pg with versions: 1.3.0

[wzrdtales]

not officially supported. You can have multiple scopes: https://db-migrate.readthedocs.io/en/latest/Getting%20Started/commands/#scoping . Scopes have db switching support.

https://github.com/db-migrate/pg/blob/b64a02aefff39af750099c5c57bb74ab47937d05/index.js#L128
This is the relevant endpoint, for pg you can actually only switch the schema not the database. Which is due to this method also theoretically callable from the driver and the non guarantee of being able to switch the db on the same connection.