why i have this error

sql
select * from storage.buckets.id = "hiking-picture"::text

``Failed to validate sql query: syntax error at or near "="``

Postgres uses single quotes only for strings.

Doesn't need the dot to be replaced with

where

The whole thing seems a mess....

select * from storage.buckets where id = 'hiking-picture'

works without ::text but does not hurt to add it.

@garyaustin because if i understand what wrong with this simple query i can understand what this

sql
create policy insert_as_admin ON storage.buckets.id = 'hiking-picture'::text for all using (
(EXISTS ( SELECT 1
   FROM profiles
  WHERE ((profiles.admin IS TRUE) AND (profiles.id = 'bi215-8e02-6c3f13e05026'::uuid))))
);`

do not pass work

I have no idea what you are trying to do with that... If you want to insert files into a "bucket" you need to set policy on the storage.object table like: https://supabase.com/docs/guides/storage#allow-logged-in-access-to-a-bucket Only for insert

it was modified whit what you teach me but still syntax error at where

sql
create policy insert_as_admin ON storage.buckets WHERE id = 'hiking-picture' for all using(
  exists(select 1 from profiles WHERE profiles.admin is true)
)

that is not how you set a policy. You were showing a select.

insert update delete etc

Can you use the storage UI on an SB instance or are you on your own hosted platform?

sb instance ?

From that link you would use this for all from signed in users

create policy "Restricted Access"
on storage.objects for all
using (
  bucket_id = 'hiking-picture'
  and auth.role() = 'authenticated'
);

You would then modify the and to be your exists part.

ok ok but i tried sql editor for learning purpose. if i get it i could add more complex sql query

So try what I showed you and see if you can upload then change the auth.role() part to be your exists statement (or what ever ends up working for your desire) using ALTER POLICY

thank you guys