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+i5Jwbfdn4Ai+dX2KtgUmYAZwWOH_n+=V9X9_Lhh_vONraeZw@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>)
List pgsql-sql


On Sunday, 20 February 2022, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Sat, Feb 19, 2022 at 5:58 PM Shaozhong SHI <shishaozhong@gmail.com> wrote:
It is impossible to produce any self-contained example.

We are talking about a data table and pure SQL, it is not impossible to produce a self-contained example.  Even if said example fails to produce the desired behavior.

Another approach is to run psql and capture everything to a text file and share that - so even without the reproducer we can see exactly what you are seeing.

David J.
That did not work at all.  I was given data sets to examine.  These got loaded with ogr2ogr.  But very strange behavior occur as I described in Posters.
Made copy back to disk.  The key and value mentioned disappeared.
Regards, David 

pgsql-sql by date:

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