1CREATE TABLE fruits ( 2 id int, 3 items jsonb 4); 5 6INSERT INTO fruits VALUES (1, '{"name": "apple"}'); 7INSERT INTO fruits VALUES (2, '{"type": "apple"}'); 8INSERT INTO fruits VALUES (3, '{"name": "peach"}'); 9 10SET enable_seqscan = on; 11SET enable_indexscan = off; 12SET enable_bitmapscan = off; 13 14SELECT id, items 15 FROM fruits 16 WHERE items &` 'string == "apple"' 17 ORDER BY id; 18 19DROP TABLE fruits; 20