Re: Turn a json column into a table

Поиск
Список
Период
Сортировка
От Shaozhong SHI
Тема Re: Turn a json column into a table
Дата
Msg-id CA+i5Jwbfdn4Ai+dX2KtgUmYAZwWOH_n+=V9X9_Lhh_vONraeZw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Turn a json column into a table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Turn a json column into a table
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Aw: Re: Turn a json column into a table