title: Selecting data into a Postgres array
body: <p>I have the following data:</p>
  
  <pre><code>name          id             url
  
  John          1              someurl.com
  Matt          2              cool.com
  Sam           3              stackoverflow.com
  </code></pre>
  
  <p>How can I write an SQL statement in Postgres to select this data into a multi-dimensional array, i.e.:</p>
  
  <pre><code>{{John, 1, someurl.com}, {Matt, 2, cool.com}, {Sam, 3, stackoverflow.com}}
  </code></pre>
  
  <p>I've seen this kind of array usage before in Postgres but have no idea how to select data from a table into this array format.</p>
  
  <p>Assuming here that all the columns are of type <code>text</code>.</p>