Content-Type: multipart/alternative;
 boundary="------------muv27KEtUBFbSI9MFWLp6ks0"
Message-ID: <93873f95-ae08-b1b9-cfe7-5fd1be777dc6@gmail.com>
Date: Sat, 19 Feb 2022 15:46:51 -0700
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.6.0
Subject: Re: Turn a json column into a table
Content-Language: en-CA
To: pgsql-sql@lists.postgresql.org
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>
From: Rob Sargent <robjsargent@gmail.com>
In-Reply-To: 
 <CA+i5JwZiT0zhMjPq4YzHbgrEV6ZVvjjuP6zvhCXBXCJU+URyuA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/93873f95-ae08-b1b9-cfe7-5fd1be777dc6%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------muv27KEtUBFbSI9MFWLp6ks0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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?

--------------muv27KEtUBFbSI9MFWLp6ks0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 2/19/22 15:40, Shaozhong SHI wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CA+i5JwZiT0zhMjPq4YzHbgrEV6ZVvjjuP6zvhCXBXCJU+URyuA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr"><br>
        </div>
        <br>
        <div class="gmail_quote">
          <div dir="ltr" class="gmail_attr">On Tue, 15 Feb 2022 at
            08:37, Karsten Hilbert &lt;<a
              href="mailto:Karsten.Hilbert@gmx.net"
              moz-do-not-send="true" class="moz-txt-link-freetext">Karsten.Hilbert@gmx.net</a>&gt;
            wrote:<br>
          </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
            0.8ex;border-left:1px solid
            rgb(204,204,204);padding-left:1ex">Hi Ion,<br>
            <br>
            &gt; there seems to be an example in the archives<br>
            &gt; <a
href="https://www.postgresql.org/message-id/20180526150323.GB28324%40momjian.us"
              rel="noreferrer" target="_blank" moz-do-not-send="true"
              class="moz-txt-link-freetext">https://www.postgresql.org/message-id/20180526150323.GB28324%40momjian.us</a><br>
            <br>
            Many thanks !   I shall indeed go Read The Fine Manual now.<br>
            <br>
            In case I might have further questions I would like to come
            back,<br>
            post my work and understanding, and ask for specific
            guidance on<br>
            the aspects I can't fully solve myself.<br>
            <br>
            Thanks again,<br>
            Karsten<br>
             <br>
          </blockquote>
          <div>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.</div>
          <div><br>
          </div>
          <div>Is there a way to cast json column as text, and extract
            values from text?</div>
          <div><br>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    Nothing in <a class="moz-txt-link-freetext" href="https://www.postgresql.org/docs/14/functions-json.html">https://www.postgresql.org/docs/14/functions-json.html</a>
    helps?<br>
    <br>
  </body>
</html>

--------------muv27KEtUBFbSI9MFWLp6ks0--