Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

No rows returned from select * from storage.objects

Hi, I have several files stored in Supabase storage but when I run "SELECT * FROM storage.objects" in the Supabase SQL Editor I get "Success, no rows returned" but when I run the same query from pgAdmin it returns the expected content. I was under the impression that queries executed from inside the Supabase SQL Editor would be running as the same default "postgres" user so the same permissions etc should be applied. Am I missing something important here?

SQL editor is "higher privilege" (supabase_admin) than postgres user.  I don't know how that would cause an RLS issue with your query though.

So SQL Editor should definitely bypass any policies that are configured? Is anybody else able to confirm that running select * from storage.objects returns results for them when they have files present in storage?