© 2026 Hedgehog Software, LLC

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

Querying Multiple Keys of JSONB

Hello, in the Supabase Docs, we have this syntax to query JSONB key, which is
->
->
.
const { data, error } = await supabase
  .from('users')
  .select(`
    id, name,
    address->city
  `)
const { data, error } = await supabase
  .from('users')
  .select(`
    id, name,
    address->city
  `)

If we want to query multiple keys of JSONB, how can I do that? Can I do something like this to prevent repetitive?
address -> (city, district, postcode)
address -> (city, district, postcode)
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

Array of jsonb .or() not working
SupabaseSSupabase / help-and-questions
4y ago
multiple foreign keys in one table
SupabaseSSupabase / help-and-questions
4y ago
array of foreign keys
SupabaseSSupabase / help-and-questions
4y ago
Identity uniqueness by multiple columns or keys
SupabaseSSupabase / help-and-questions
4y ago