Concat all result columns into a single string in PostgreSQL
18:58 20 Jan 2013

I need connect all columns (unknown columns) from each row rows to one string.

I want do something like this:

select concat(*) from table;

The problem is that the function concat doesn't take parameter "*".

How can I do this?

Example

Table

GID | Name
----------
1   | nameA
2   | nameB
3   | nameC

Desired output:

1nameA
2nameB
3nameC
sql postgresql postgresql-9.1