Home > mailing lists

Turn a json column into a table - Mailing list pgsql-general

From	Shaozhong SHI
Subject	Turn a json column into a table
Date	February 15, 2022 06:23:59
Msg-id	CA+i5Jwa8bLKBWPYTrn0dsAKKFR9m1L1eFtj_vaCwBWqa4ibUZg@mail.gmail.com Whole thread Raw
Responses	Re: Turn a json column into a table
List	pgsql-general

Tree view

There is a JSON column in a table. It contains key value pairs, just like a dictionary. What is the best way to turn this column into a data table?

Regards,

David

pgsql-general by date:

From: Michael Lewis
Date: 15 February 2022, 06:03:23
Subject: Re: Rows From but with Subqueries (or a cleaner non-array-using alternative)?

From: Thomas Kellerer
Date: 15 February 2022, 06:27:29
Subject: Re: Turn a json column into a table

Turn a json column into a table - Mailing list pgsql-general

Previous

Next