title: Postgres concat all
body: <p>I need connect all columns (unknown columns) from every rows to one string</p>
  
  <p>I want do sth like this: </p>
  
  <pre><code>select concat(*) from table;
  </code></pre>
  
  <p>The problem is that the function concat doesn't take parameter "*"</p>
  
  <p>Anyone can help me?</p>
  
  <p>Example:</p>
  
  <p>Table</p>
  
  <pre><code>GID | Name
  ----------
  1   | nameA
  2   | nameB
  3   | nameC
  </code></pre>
  
  <p>I need on output:</p>
  
  <pre><code>1nameA
  2nameB
  3nameC
  </code></pre>