TIL - How to search inside json blob in PostgreSQL
To dig into a json blob in
SELECT * FROM public.app_storedconversations
WHERE conversation->'messages' @> '[{"id": "2c43c955-3fe4-46bc-af98-446fd277d966"}]';
To dig into a json blob in
SELECT * FROM public.app_storedconversations
WHERE conversation->'messages' @> '[{"id": "2c43c955-3fe4-46bc-af98-446fd277d966"}]';