Select from

[marcusraty]

Bug report

Describe the bug

https://supabase.com/docs/guides/storage/security/access-control

According to the storage guide there is a storage.objects table. I expected to be able to fetch data from it (with appropriate RLS), however I am getting the error:

PostgrestError(details: nil, hint: nil, code: Optional("42P01"), message: "relation \"public.storage.objects\" does not exist")

To Reproduce

I am using the following code:

            let result = try await supabaseClient.database
                .from("storage.objects")
                .select()
                .eq("name", value: "path_that_exists")
                .execute()

Expected behavior

Should we be able to query storage.objects? I took the idea from here: supabase/storage#266

[marcusraty]

I misunderstood what was suggested in here: supabase/storage#266

I was able to get this working but making a postgres function and calling that via .rpc