Postgres Pro
Downloads
Home   >   mailing lists

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

From Shaozhong SHI
Subject Re: Turn a json column into a table
Date
Msg-id CA+i5JwY6P6jcqcOdnaJYbLB55s-wRkvHcMdVs86Cqf6g9Md9Hg@mail.gmail.com
Whole thread Raw
In response to Re: Turn a json column into a table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Turn a json column into a table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Aw: Re: Turn a json column into a table  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-sql
Tree view


On Sun, 20 Feb 2022 at 00:18, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Saturday, February 19, 2022, Shaozhong SHI <shishaozhong@gmail.com> wrote:

That is a very odd challenge.  That key and value do appear in the data set but it will disappear whenever you do something with the json column.

Your observations of this sort aren’t that useful.  What would be useful, like always, is a self-contained example.

David J.

It is impossible to produce any self-contained example.

It can be seen but difficult to get a grip of it to show you.  So odd.

Regards,

David 

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Turn a json column into a table
Next
From: "David G. Johnston"
Date:
Subject: Re: Turn a json column into a table