Re: Re: Turn a json column into a table

From: Ion Alberdi <ion(dot)alberdi(at)pricemoov(dot)com>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Re: Turn a json column into a table
Date: 2022-02-15 08:11:42
Message-ID: CANbgw4AR3ObySD_z-KRE=qzf+BUn+ZvArqoWXiyHvGt3HtJqxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Karsten,
there seems to be an example in the archives
https://www.postgresql.org/message-id/20180526150323.GB28324%40momjian.us

Le mar. 15 févr. 2022 à 09:09, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> a
écrit :

> 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ion Alberdi 2022-02-15 08:15:28 Storing thousands of csv files in postgresql
Previous Message Karsten Hilbert 2022-02-15 08:09:32 Aw: Re: Turn a json column into a table