Postgres Pro
Downloads
Home   >   mailing lists

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

From Shaozhong SHI
Subject Turn a json column into a table
Date
Msg-id CA+i5JwaLk91tgZi66yQxLx6ceaGGLpS-Xrb_kFGAMBY_G4JGYA@mail.gmail.com
Whole thread Raw
Responses Re: Turn a json column into a table
List pgsql-sql
Tree view
There is a JSON column in a table.  It contains key value pairs, just like a dictionary.  

Keys are column names.  Values are values contained in a row.

It looks like that each JSON object needs to be expanded into row values in different columns.

What is the best way to turn this JSON column into a data table?

Regards,

David

pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: How best to work around the issue - regex string cannot contain brackets
Next
From: Ion Alberdi
Date:
Subject: Re: Turn a json column into a table