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.