How to use different schemas with Postgres?

rickbergfalk / postgrator

A PostgreSQL, MySQL, and SQL Server migration tool using plain sql scripts.

MIT License

449 stars 70 forks source link

How to use different schemas with Postgres? #158

Open alexvictoor opened 2 years ago

alexvictoor commented 2 years ago

Hello The doc mentions the "SET search_path" command. Is there an easy way to runn this command prior to postgrator migrations? Will postgrator create a schemaversion table in the specified schema? Thanks in advance for your help

Alex

rickbergfalk commented 2 years ago

The search_path will be set and run automatically prior to running migrations, so there shouldn't be any need to run it yourself. It is more an implementation detail so that you are aware how it is accomplishing things.