I have a collection of (basically static) reference data for my app, which is loaded separately into a Postgres schema reference_data. I want to query data from tables in that schema in my app’s Ecto queries. My first attempt was: from parcel in "reference_data.living_england_habitat_map_phase_4", …

Thanks @al2o3cr . I hadn’t actually declared a schema for that table, but having done so and added the @schema_prefix, my query is working. According to some StackOverflow posts that I read, it is OK to query a table directly without creating an Ecto schema for it first, so I still don’t know if it’…

It is possible: Repo.all(query, prefix: "reference_data")

Elixir Programming Language Forum

Reference data table in PostgreSQL schema

Questions & Help Questions

al2o3cr August 12, 2022, 3:52pm 2

The @schema_prefix option sounds like what you’re looking for.