© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
2 replies
iLikeBikes

RLS Policy with array

Hey all,
I have an RLS policy that I am trying to update from a string to an array. Currently it takes one string, but I want it to take a list of strings that map to a column.

I have setup using the community custom claims library and my original rls function was setup as

(get_my_agency() = agency)
(get_my_agency() = agency)


but what I want is something like this

(agency contains(get_my_agencies())
(agency contains(get_my_agencies())


is this possible or performnat?


https://github.com/supabase-community/supabase-custom-claims
GitHub
GitHub - supabase-community/supabase-custom-claims: How to implemen...
How to implement custom claims with Supabase. Contribute to supabase-community/supabase-custom-claims development by creating an account on GitHub.
GitHub - supabase-community/supabase-custom-claims: How to implemen...
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

RLS Policy
SupabaseSSupabase / help-and-questions
4mo ago
RLS Policy With Join
SupabaseSSupabase / help-and-questions
4y ago
need help with RLS policy
SupabaseSSupabase / help-and-questions
5mo ago
Issues with UPDATE RLS policy
SupabaseSSupabase / help-and-questions
5mo ago