title: How to transpose row to column in Postgres 9.5?
body: <p>I have this table in input, it contains always only three rows.</p>
  
  <pre><code>| data |  
  --------
  |   X  | 
  |   Y  |
  |   Z  |
  </code></pre>
  
  <p>And I want this output:</p>
  
  <pre><code>| data1| data2 | data3 |
  -------+-------+-------+
  |   X  |   Y   |   Z   |
  </code></pre>
  
  <p>I have tried to use the <code>crosstab</code> function, but as far as I understand it need more information, like a category column and a row_name column. I don't have them.</p>
  
  <p>Is possible to transpose this table?</p>