title: Postgresql get keys from array of objects in JSONB field
body: <p>Here' a dummy data for the jsonb column</p>
  
  <pre><code>[ { "name": [ "sun11", "sun12" ], "alignment": "center", "more": "fields" }, { "name": [ "sun12", "sun13" ], "alignment": "center" }, { "name": [ "sun14", "sun15" ] }]
  </code></pre>
  
  <p>I want to fetch all the name keys value from jsonb array of objects...expecting output -</p>
  
  <pre><code>[ [ "sun11", "sun12" ], [ "sun12", "sun13" ], [ "sun14", "sun15" ] ]
  </code></pre>
  
  <p>The problem is that I'm able to fetch the name key value by giving the index like 0, 1, etc</p>
  
  <pre><code>SELECT data-&gt;0-&gt;'name' FROM public."user";
  [ "sun11", "sun12" ]
  </code></pre>
  
  <p>But I'm not able to get all the name keys values from same array of object.I Just want to get all the keys values from the array of json object. Any help will be helpful. Thanks </p>