Turn a json column into a table

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.