Thread: 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.