title: How to parse JSON Array to update record in postgreSQL
body: <p>I have a Table name called employee_Details with Columns</p>
  
  <pre><code> EMP_ID   NAME  VECH_NO  SALARY
     1       A      1234    100
     2       B      12345   200
  </code></pre>
  
  <p>I Construct JSON array using Java. with structure </p>
  
  <blockquote>
    <p>{["EMP_ID":1,"NAME":Y,"VECH_NO":4587,"SALARY":1500],["EMP_ID":3,"NAME":Z,"VECH_NO":4007,"SALARY":1800]}</p>
  </blockquote>
  
  <p>I need to update full record where EMP_ID exists on table else insert as new record. There is any in build function available in postgreSQL to achieve this. I refer this <a href="https://www.postgresql.org/docs/9.3/static/functions-json.html" rel="nofollow">https://www.postgresql.org/docs/9.3/static/functions-json.html</a> but didn't get solution </p>