title: How to select column with json without sending column name?
body: <p>I'm setting up an API with Node and postgreSQL-node (pg), and when I query for the column in my data base that contains JSON it returns an array of objects with the columns name and the json I want to access.</p>
  
  <p>My current query is: </p>
  
  <pre><code>select jsondata 
  from breweries
  </code></pre>
  
  <p>The output is:</p>
  
  <pre><code>[
      {
          "jsondata": {
              "id": 2,
              "name": "Avondale Brewing Co",
              "brewery_type": "micro",
              "street": "201 41st St S",
              "city": "Birmingham",
              "state": "Alabama",
              "postal_code": "35222-1932",
              "country": "United States",
              "longitude": "-86.774322",
              "latitude": "33.524521",
              "phone": "2057775456",
              "website_url": "http://www.avondalebrewing.com",
              "updated_at": "2018-08-23T23:19:57.825Z",
              "tag_list": []
          }
      },
      {"jsondata": {...}}, 
      {...}
  ]
  </code></pre>
  
  <p>My expectation is to get and array with the contents inside "jsondata" without the name of the column "jsondata", but I can't find a way to access it one level in my query.</p>
  
  <p>Edit: 
  Here is what I expect:</p>
  
  <pre><code>[
      {
  
              "id": 2,
              "name": "Avondale Brewing Co",
              "brewery_type": "micro",
              "street": "201 41st St S",
              "city": "Birmingham",
              "state": "Alabama",
              "postal_code": "35222-1932",
              "country": "United States",
              "longitude": "-86.774322",
              "latitude": "33.524521",
              "phone": "2057775456",
              "website_url": "http://www.avondalebrewing.com",
              "updated_at": "2018-08-23T23:19:57.825Z",
              "tag_list": []
  
      },
      {...}, 
      {...}
  ]
  </code></pre>