I’m doing some reading around prefixes and came across the very useful Multi tenancy with query prefixes — Ecto v3.6.2 (hexdocs.pm) but I’m a bit confused about how to create a prefix in the first place.
The linked article does so using a psql command but ideally I’d like this to be completed via Ecto as that is where the rest of the database set up is handled. Looking through the documentation for Ecto.Schema and Ecto.Migration I can’t find anything about creating a “prefix” schema.
Any pointers to the correct direction would be appreciated.