Quick Links

Aw: Re: Turn a json column into a table

From:	Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To:
Cc:	pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject:	Aw: Re: Turn a json column into a table
Date:	2022-02-15 08:09:32
Message-ID:	trinity-5d1e8383-e15e-4cbd-a4bf-7e55bf0cffb7-1644912572863@3c-app-gmx-bs21
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

Hi Ion,

> it seems (json_to_record, jsonb_to_record) may help in this use case.
> https://www.postgresql.org/docs/9.4/functions-json.html

json_to_record seems promising. Is there any excellent Postgresql example ?

Karsten

In response to

Re: Turn a json column into a table at 2022-02-15 07:52:18 from Ion Alberdi

Responses

Re: Re: Turn a json column into a table at 2022-02-15 08:11:42 from Ion Alberdi
Re: Re: Turn a json column into a table at 2022-02-19 22:03:12 from Shaozhong SHI

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Ion Alberdi	2022-02-15 08:11:42	Re: Re: Turn a json column into a table
Previous Message	Ion Alberdi	2022-02-15 07:52:18	Re: Turn a json column into a table