Hi. I recently connected my Supabase database, but I encountered an issue with the n8n module. It only displays the tables under the public schema, and I couldn’t find any information on setting up other schemas. Can you please confirm if support for other schemas is currently available?
While I’m not familiar with Supabase at all, it looks like this is a limitation of Supabase by default. Have you tried to expose the schema in the Supabase settings?
Yes, I tried adding the schema to the exposed schema list in the API settings, but it didn’t work (((
@mixuci Can you try these additional steps as well? I’m not too sure if this will work, but:
CREATE SCHEMA Foo; GRANT USAGE ON SCHEMA Foo TO postgres, anon, authenticated, service_role, dashboard_user; ALTER DEFAULT PRIVILEGES IN SCHEMA Foo GRANT ALL ON TABLES TO postgres, anon, authenticated, service_role, dashboard_user;
And then also:
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA foo TO postgres, authenticated, service_role, dashboard_user, anon; GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA foo TO postgres, authenticated, service_role, dashboard_user, anon;
I successfully established a connection to the Supabase database using the Postgres node, effectively resolving all of my issues. Thank you very much for your assistance.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.