© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•13mo ago•
16 replies
Jayani

Exposing non-public schema to postgrest

I am trying to set up a users schema not in the public schema to handle permissions. I HAVE set the schema to be exposed in settings/API.
But when trying to query the api it seems to default to the public schema.

response = supabase.table('users.user_details').select("*").execute()
throws error:
Error fetching user details: {'code': '42P01', 'details': None, 'hint': None, 'message': 'relation "public.users.user_details" does not exist'}
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Exposing Schema
SupabaseSSupabase / help-and-questions
5mo ago
API Docs for non-public Schema
SupabaseSSupabase / help-and-questions
3y ago
PostgREST Schema Cache issue – `PGRST002`
SupabaseSSupabase / help-and-questions
5mo ago
Custom Schema and Exposing APIs
SupabaseSSupabase / help-and-questions
13mo ago