S

Supabase•13mo ago•

2 replies

Sergej

Supabase Airtable Wrapper Postman API Request problem

Hello. I was creating my Airtable Wrapper with Supabase Dashboard. My Postgres-Airtable Table is there and has all related data. Now I have a problem how to get all that data after Postman request? My Postgres-Airtable Table is in public schema. I also tryied to move a foreign table to custom schema, but it did not help me. SQL Editor for select works.

I also used tips from "https://supabase.com/docs/guides/api/using-custom-schemas?queryGroups=language&language=curl", but no result

CREATE SCHEMA myschema;

GRANT USAGE ON SCHEMA myschema TO anon, authenticated, service_role;
GRANT ALL ON ALL TABLES IN SCHEMA myschema TO anon, authenticated, service_role;
GRANT ALL ON ALL ROUTINES IN SCHEMA myschema TO anon, authenticated, service_role;
GRANT ALL ON ALL SEQUENCES IN SCHEMA myschema TO anon, authenticated, service_role;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myschema GRANT ALL ON TABLES TO anon, authenticated, service_role;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myschema GRANT ALL ON ROUTINES TO anon, authenticated, service_role;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myschema GRANT ALL ON SEQUENCES TO anon, authenticated, service_role;

Using Custom Schemas | Supabase Docs

You need additional steps to use custom database schemas with data APIs.