Skip to content
Advertisement

Find data from json/jsonb column by array in Postgresql

I have a column with json/jsonb data. Database is postgresql.

column data sample

{"postId": "p522", "groupId": "g11", ...}
{"postId": "p5ds", "groupId": "g234", ...}
{"postId": "p5cz", "groupId": "g597", ...}

I am trying to search as an array of data from json/jsonb column.

What’s best or right way to do it?

SELECT * FROM column_name
WHERE 
-- How i can do, similar to this? 
data #> '{groupId}' IN ('g11', 'g597')

-- this works but only for single. I am trying to find by array. 
meta @> '{"groupId": "g597"}' 

Advertisement

Answer

Solved:

SELECT * FROM column_name 
WHERE meta ->> 'groupId' IN ('g11', 'g597')
User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement