Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Turn a json column into a table - Mailing list pgsql-sql

From Ion Alberdi
Subject Re: Re: Turn a json column into a table
Date
Msg-id CANbgw4AR3ObySD_z-KRE=qzf+BUn+ZvArqoWXiyHvGt3HtJqxA@mail.gmail.com
Whole thread Raw
In response to Aw: Re: Turn a json column into a table  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Aw: Re: Re: Turn a json column into a table  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-sql
Tree view
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.Hilbert@gmx.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



pgsql-sql by date:

Previous
From: Karsten Hilbert
Date:
Subject: Aw: Re: Turn a json column into a table
Next
From: Ion Alberdi
Date:
Subject: Storing thousands of csv files in postgresql