agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Rob Sargent <robjsargent@gmail.com>
To: pgsql-sql@lists.postgresql.org
Subject: Re: Turn a json column into a table
Date: Sat, 19 Feb 2022 15:46:51 -0700
Message-ID: <93873f95-ae08-b1b9-cfe7-5fd1be777dc6@gmail.com> (raw)
In-Reply-To: <CA+i5JwZiT0zhMjPq4YzHbgrEV6ZVvjjuP6zvhCXBXCJU+URyuA@mail.gmail.com>
References: <CA+i5JwaLk91tgZi66yQxLx6ceaGGLpS-Xrb_kFGAMBY_G4JGYA@mail.gmail.com>
<CANbgw4DwDkSxZ1rn10rdHS51fy3vGQqN73sEDvg9GRH3WPE=aw@mail.gmail.com>
<trinity-5d1e8383-e15e-4cbd-a4bf-7e55bf0cffb7-1644912572863@3c-app-gmx-bs21>
<CANbgw4AR3ObySD_z-KRE=qzf+BUn+ZvArqoWXiyHvGt3HtJqxA@mail.gmail.com>
<trinity-bc4d6f10-0640-4cc0-a273-f170bc669041-1644914256278@3c-app-gmx-bs21>
<CA+i5JwZiT0zhMjPq4YzHbgrEV6ZVvjjuP6zvhCXBXCJU+URyuA@mail.gmail.com>
On 2/19/22 15:40, Shaozhong SHI wrote:
>
>
> 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?
>
Nothing in https://www.postgresql.org/docs/14/functions-json.html helps?
view thread (12+ messages) latest in thread
Message-ID: <93873f95-ae08-b1b9-cfe7-5fd1be777dc6@gmail.com>
Permalink: ../93873f95-ae08-b1b9-cfe7-5fd1be777dc6@gmail.com/
Also on: postgresql.org/message-id/93873f95-ae08-b1b9-cfe7-5fd1be777dc6@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com, pgsql-sql@lists.postgresql.org
Subject: Re: Turn a json column into a table
In-Reply-To: <93873f95-ae08-b1b9-cfe7-5fd1be777dc6@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox