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
|
| Список | 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 по дате отправления: