title: How to get JSONB data in additional columns from Postgres
body: <p>I have a table from which I want to fetch two fields of which one is JSONB with JSONB values in to new columns.</p>
  
  <pre><code>SELECT ID, ATTRIBS from EMPLOYEE;
  </code></pre>
  
  <p>This returns me the output as follows.</p>
  
  <pre><code>   id  |                attribs
  ------------------------------------------------------------------------------------
   EM001 | {"Education": "C.A.", "Contact No": "6655448822", "Relative Name": "Ganga"}
   EM002 | {"Education": "M.E.", "Contact No": "6542349992", "Relative Name": "Yamuna"}
  </code></pre>
  
  <p>I would like to have the output as follows</p>
  
  <pre><code>   id  | Education | Contact No | Relative Name
  -----------------------------------------------
   EM001 | C.A.      | 6655448822 | Ganga
   EM002 | M.E.      | 6542349992 | Yamuna
  </code></pre>
  
  <p>Any suggestions how I can do this?</p>