PostgreSQL常见SQL查询
1.现有表A如下数据, 表字段 Id, receiver,status,amount; receiver字段为JSONB类型
id
member_id
receiver
status
amount
month
1
1000
{“name”: “张三”, “account”: “13100000000”}
1
22.22
2022-01
2
1001
{“name”: “李四”, “account”: “13100000001”}
2
11.11
2022-02
3
1002
{“
原创
2022-01-13 18:00:50 ·
768 阅读 ·
0 评论