Re: 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_c

Turn a json column into a table

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? Regards, David