postgresql对jsonb类型字段操作

https://elemefe.github.io/
SELECT (extension ::jsonb->> ‘sex’)::jsonb->>’sex’ FROM “accounts” WHERE extension ::jsonb->> ‘sex’ is not null