I have a Supabase PostgreSQL database with multiple schemas that contain tables that I want to connect to from Weweb. I reviewed a similar post from January 2023 that basically indicated this was not currently possible.
Has there been any advancements made that will allow connecting to non-public schemas in Supabase PostgreSQL database from Weweb?
Not possible still, only maybe with a custom script.
Thank you
@Alexis I found that Supabase now allows Using Custom Schemas | Supabase Docs, it might be interesting to have this in the Supabase plugin, I heard you guys are re-vamping it a little.
Hey Perry, I ran into the exact same issue recently and the most reasonable solution I found was to create views in the public schema that point to the tables in your additional Supabase schema.
That way, WeWeb can interact with them as if they were regular tables in public.
For example, you can do this for each table you need:
create or replace view public.YOUR-schema_YOUR-table as
select * from your_schema.YOUR-schema_YOUR-table;
After that, you’ll be able to query public.schema_table from WeWeb without worrying about schema limitations.