Multiple schemas in pgroll

Is it possible to migrate multiple schemas in pgroll? Let's say I have a public and a private schema, can I migrate both and keep them in sync with each other?
2 Replies
kostas
kostas9mo ago
Hi, the --schema parameter can be used to specify the postgres schema in which to run migrations. As for running the same migrations to multiple schemas, you can check out the suggestions in this issue about reusing migration files: https://github.com/xataio/pgroll/issues/183#issuecomment-1752551714
squirrelmaster
squirrelmasterOP9mo ago
Thank you!

Did you find this page helpful?