json是这样 sql: SELECT * FROM your_table where content::json->'properties'->>'idNewMapNu' = 'AA' content是表中的字段