title: Split a JSON column in postgres sql
body: <p>I have a table with a column that has JSON value. This column is so clustered and unable to get detailed information from the column.</p>
  <pre><code>   Company     User
      A   [{&quot;Name&quot;:&quot;Mark&quot;,&quot;email&quot;:&quot;mark.com&quot;,&quot;password&quot;:&quot;password&quot;},{&quot;Name&quot;:&quot;Keith&quot;,&quot;email&quot;:&quot;Keith.com&quot;,&quot;password&quot;:&quot;password&quot;}]
      B   [{&quot;Name&quot;:&quot;Anna&quot;,&quot;email&quot;:&quot;anna.com&quot;,&quot;password&quot;:&quot;password&quot;},{&quot;Name&quot;:&quot;Lewis&quot;,&quot;email&quot;:&quot;Lewis.com&quot;,&quot;password&quot;:&quot;password&quot;}]
      C   [{&quot;Name&quot;:&quot;Bill&quot;,&quot;email&quot;:&quot;bill.com&quot;,&quot;password&quot;:&quot;password&quot;},{&quot;Name&quot;:&quot;Stuart&quot;,&quot;email&quot;:&quot;stuart.com&quot;,&quot;password&quot;:&quot;password&quot;}]
  </code></pre>
  <p>Is there any way we can break the column as below in a select statement</p>
  <pre><code>Company User_1_name User_1_email User_1_password User_2_name User_2_email User_2_password
  A         Mark      mark.com       password        Keith      Keith.com     password
  B         Anna      anna.com       password        Lewis      Lewis.com     password
  C         Bill      bill.com       password        Stuart     stuart.com    password
  </code></pre>