title: Postgres : Get name value from json array using SELECT
body: <p>In a column say <strong>details</strong> the values are stored as: </p>
  
  <pre><code>[{"id":"key1","name":"Concerts \u0026amp; Tour Dates"},{"id":"key2","name":"Nightlife \u0026amp; Singles"}]
  </code></pre>
  
  <p>Column Type: text</p>
  
  <p>I need to get comma separated value for name using a single SELECT statement.Also need the amp sign.</p>
  
  <p>Result:
  [Concerts &amp; Tour Dates,Nightlife &amp; Singles]</p>