guys, what is the difference between these 2?
# helpa
AnishDe12020
10/04/2021, 4:18 AMguys, what is the difference between these 2?
g
garyaustin
10/04/2021, 5:04 AMSo I’m just new to Supabase but find Googling PostgreSQL on detailed Database things works best. This link helped me understand RLS. https://sagargulabani.medium.com/row-level-security-in-postgresql-5d26cdd6a07d
Basically Using is for read or delete. With Check is for insert and update needs both as it reads and writes.
a
AnishDe12020
10/04/2021, 5:05 AMoh
AnishDe12020
10/04/2021, 5:10 AMI have just used
USINGg
garyaustin
10/04/2021, 5:27 AMSo I’m out over my skis here, but I believe update will default the With Check to the using, but insert needs With Check.
a
AnishDe12020
10/04/2021, 5:39 AMoh wait, insert defaults to with check
AnishDe12020
10/04/2021, 5:39 AMso ya i am using with check for insert