Postgres Pro
Downloads
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
Msg-id CA+i5Jwa8bLKBWPYTrn0dsAKKFR9m1L1eFtj_vaCwBWqa4ibUZg@mail.gmail.com
Whole thread Raw
Responses Re: Turn a json column into a table  (Thomas Kellerer <shammat@gmx.net>)
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:

Previous
From: Michael Lewis
Date:
Subject: Re: Rows From but with Subqueries (or a cleaner non-array-using alternative)?
Next
From: Thomas Kellerer
Date:
Subject: Re: Turn a json column into a table