Skip to content

re: A dive into database multi-tenancy in Elixir with Ecto VIEW POST


Do you know if there's a way to use the prefix option with Postgres, but have it point to different databases?


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.

code of conduct - report abuse