DEV Community

Discussion on: A dive into database multi-tenancy in Elixir with Ecto

Collapse
 
dreamingechoes profile image
Iván González Sáiz

Hi Daniel!

I think is not possible to change between different databases using the prefix option with Postgres. If you check the official documentation, you can read: "For Postgres users, this will specify the schema where the table is located, while for MySQL users this will specify the database where the table is located". Postgres uses its schemas for the multi-tenancy, not different databases.