How to search a specific string in JSON or JSONB array in PostgreSQL ?

I have a column called meta_data whose data type is JSONB data type which deals with JSON array. And let’s say you wanted to find rows that contains the string “deviceid” in the meta_data column (JSONB data type) in audit… Read More!