Hi David,
it seems (json_to_record, jsonb_to_record) may help in this use case.
https://www.postgresql.org/docs/9.4/functions-json.html
Regards
Le mar. 15 févr. 2022 à 08:21, Shaozhong SHI <shishaozhong(at)gmail(dot)com> a
écrit :
> There is a JSON column in a table. It contains key value pairs, just like
> a dictionary.
>
> Keys are column names. Values are values contained in a row.
>
> It looks like that each JSON object needs to be expanded into row values
> in different columns.
>
> What is the best way to turn this JSON column into a data table?
>
> Regards,
>
> David
>