Concat all result columns into a single string in PostgreSQL
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