It is necessary to make multiple columns in psql. I do this through concat_ws, but then we have a space at the end of each line. rtrim does not help. Example

SELECT rtrim(CONCAT_WS(' ', '"', 'adidas', 'rebook', 'nike', '"' )) 

"adidas rebook nike" result

    1 answer 1

     CONCAT('"', CONCAT_WS(' ', 'adidas', 'rebook', 'nike'), '"')