By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
select '[{\"value\":\"TB12\",\"label\":\"Tom Brady\"},{\"value\":\"TW95\",\"label\":\"Tiger Woods\"},{\"value\":\"PM10\",\"label\":\"Peyton Manning\"}]'::json
ERROR: invalid input syntax for type json LINE 1: select '[{\"value\":\"TB12\",\"label\":\"Tom Brady\"},{\"val... ^ DETAIL: Token "\" is invalid. CONTEXT: JSON data, line 1: [{\...