pg库中查询jsonb中是否包含某数据
1、字段数据为以下格式:
[{"name": "中关村高新技术企业"}, {"name": "瞪羚企业"}, {"name": "科技型中小企业"}, {"name": "高新技术企业"}]
2、查询是否包含某键值对:
SELECT * FROM pg_table WHERE qualified_name @> '[{"key": "value"}]';
3、对某键进行模糊匹配查询是否包含某数据
SELECT
count(1)
FROM
pg_table
WHERE EXISTS (
SELECT 1 FROM jsonb_array_elements(qualified_name) AS elem
WHERE elem->>'key' LIKE '%value%'
);