Shaozhong SHI schrieb am 15.02.2022 um 07:23: > There is a JSON column in a table. It contains key value pairs, just > like a dictionary. What is the best way to turn this column into a > data table?
jsonb_each() is one option:
select j.*
from the_table t
cross join jsonb_each(t.the_column) as j(key, value);
If the column uses the json type (rather than the recommended jsonb) you can
need to use json_each() instead.
