Hi all, been liking my experience with using Supab...
# helpt
T-ZA
01/17/2022, 1:39 PMHi all, been liking my experience with using Supabase so far, it's shaping up to be a great solution for my needs! I have seem to run into an interesting
If I make a new schema in Supabase with SQL (e.g. CREATE SCHEMA name) and create table(s) in it, would those tables in the new schema be visible on the Database -> Tables view of the dashboard? What should I do if they aren't?
g
garyaustin
01/17/2022, 3:29 PMProbably need to set permissions:
https://github.com/supabase/supabase/issues/4916
t
T-ZA
01/17/2022, 6:19 PMThanks for responding 🙂
I tried applying the listed grants in my project, but that didn't seem to help for this particular issue in the dashboard (definitely noted for when I start testing REST calls, though!)
g
garyaustin
01/17/2022, 6:41 PMDo they show up in the table editor UI (towards top of menu) when you select the schema? I do find it interesting the database table display UI only displays public, where as the table editor has access to all schemas...
garyaustin
01/17/2022, 6:47 PMhttps://github.com/supabase/supabase/discussions/3204 From awhile back implies they should be in database section too, but still odd to me for instance storage schema is not there. Seems odd they would filter certain schemas out. The fact that when you create a new table in the database section there is no schema option and it uses public, makes me think other schemas are not supported there and it default to public.
t
T-ZA
01/18/2022, 1:50 PMYeah, all schemas including my added one (and the tables in it) are available for me in the Tables view (sorry for responding so late)
T-ZA
01/18/2022, 1:52 PMIt might just like you said where the Database view only shows tables in public whereas the Tables view can display across all schemas 🤔