| From: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
|---|---|
| To: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
| Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Re: Re: Turn a json column into a table |
| Date: | 2022-02-19 22:40:04 |
| Message-ID: | CA+i5JwZiT0zhMjPq4YzHbgrEV6ZVvjjuP6zvhCXBXCJU+URyuA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Tue, 15 Feb 2022 at 08:37, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2022-02-19 22:46:51 | Re: Turn a json column into a table |
| Previous Message | Shaozhong SHI | 2022-02-19 22:03:12 | Re: Re: Turn a json column into a table |