Unquoting JSON strings; print JSON strings without quotes SELECT json_array_elements('["one", "two"]'::json)


gives result


| json_array_elements |
| :------------------ |
| &quot;one&quot;               |
| &quot;two&quot;               |


I would like to have the same but without the quotes:

one
two


Looks like I can't use -&gt;&gt; here because I don't have field names in the JSON. It's just an array of strings.

Postgres version:
PostgreSQL 10.0 on x86_64-apple-darwin, compiled by i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2336.11.00), 64-bit
SELECT value#&gt;&gt;'{}' as col FROM json_array_elements('["one", "two"]'::json);


Result:

col
---
one
two