Timeline for Unquoting JSON strings; print JSON strings without quotes

10 events

when toggle format	what		by	license	comment
Jun 7, 2022 at 3:40	comment	added	psmith		Note that btrim gives incorrect result if the string contains double quotes while @slava-v's answer below is better: `SELECT x, trim('"' FROM x::text), x#>>'{}' FROM json_array_elements('[null, "nu\"ll", 1, "1"]') AS t(x);`
May 28, 2018 at 4:23	vote	accept	Maxim Yefremov
May 27, 2018 at 21:44	history	edited	Evan Carroll	CC BY-SA 4.0	added 209 characters in body
May 27, 2018 at 21:32	history	edited	Evan Carroll	CC BY-SA 4.0	added 38 characters in body
May 27, 2018 at 21:19	history	edited	Evan Carroll	CC BY-SA 4.0	added 460 characters in body
May 27, 2018 at 21:02	history	edited	Evan Carroll	CC BY-SA 4.0	added 99 characters in body
May 27, 2018 at 20:57	history	edited	Evan Carroll	CC BY-SA 4.0	added 99 characters in body
May 27, 2018 at 20:51	history	edited	Evan Carroll	CC BY-SA 4.0	added 99 characters in body
May 27, 2018 at 20:37	history	edited	Evan Carroll	CC BY-SA 4.0	added 177 characters in body
May 27, 2018 at 20:30	history	answered	Evan Carroll	CC BY-SA 4.0