how to concat/concat_ws all fields without braces - Mailing list pgsql-general

From Jean Louis
Subject how to concat/concat_ws all fields without braces
Date
Msg-id 20190615061957.GD2565@protected.rcdrun.com
Whole thread Raw
Responses Re: how to concat/concat_ws all fields without braces
Re: how to concat/concat_ws all fields without braces
List pgsql-general
Hello,

I have tried doing something like:

SELECT concat_ws(' ', table.*) FROM table;

and if I do that way, it is essentially same as 

SELECT concat(table.*) FROM table;

and I get the items in braces like (1,something).

Why do I get it in braces?

Is there a way without specifying specific fields
to get all items concatenated without braces?

I would prefer conat_ws option.

Jean



pgsql-general by date:

Previous
From: Leandro Guimarães
Date:
Subject: Re: Copy Bulk Ignore Duplicated
Next
From: Rob Nikander
Date:
Subject: arrays of composite types, and client drivers like JDBC