Re: Best way to parse complex json string into table columns?

Thanks!

We are using jsonb

I'll have a look at

json[b]_populate_record





On 12/13/23 10:24, Tom Lane wrote:
> Sbob  writes:
>> I have a client that is using a function to parse a set of rows from a
>> table with a json column into table columns in a materialized view.
>> ...
>> The above approach is painfully slow, is there a better performing
>> method of converting json strings to table columns?
> json[b]_populate_record is meant for this sort of thing.
>
> Also, if your source data is actually json not jsonb, that's
> a seriously poor choice when you are in need of better
> processing speed.
>
> 			regards, tom lane