Re: Re: Re: Turn a json column into a table

Поиск
Список
Период
Сортировка
От Shaozhong SHI
Тема Re: Re: Re: Turn a json column into a table
Дата
Msg-id CA+i5JwZiT0zhMjPq4YzHbgrEV6ZVvjjuP6zvhCXBXCJU+URyuA@mail.gmail.com
обсуждение исходный текст
Ответ на Aw: Re: Re: Turn a json column into a table  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: Turn a json column into a table  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-sql


On Tue, 15 Feb 2022 at 08:37, Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
Hi Ion,

> there seems to be an example in the archives
> https://www.postgresql.org/message-id/20180526150323.GB28324%40momjian.us

Many thanks !   I shall indeed go Read The Fine Manual now.

In case I might have further questions I would like to come back,
post my work and understanding, and ask for specific guidance on
the aspects I can't fully solve myself.

Thanks again,
Karsten
 
In the JSON column, one key can be seen present as other keys.  But, when use json_object_keys, it did not turn up at all.

Is there a way to cast json column as text, and extract values from text?

Regards,

David 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: Re: Re: Turn a json column into a table
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Turn a json column into a table