Specify postgres schema to use

[Jacobh2]

Hey!

Is it possible to specify which postgres schema to use, to not be forced to use the public schema?

Would be really neat if this could be available as a config: Either an ENV, or maybe using the postgres connection string directly like postgresql://username:password@host:port/database?search_path=myschema or something similar.

[Jacobh2]

And of course 5 min after posting here I was able to find the answer, thanks ghost rubber ducking 😄

You can set the schema=myschema option to the connection string:

postgresql://username:password@localhost:5432/mydb?schema=myschema

🎉