Change delimiter for CSV response

[laurenceisla]

Question from Gitter https://gitter.im/begriffs/postgrest?at=615a8a067db1e3753e1eef7a:

I make a GET request /goods?updatetime=gt.2021-10-02%2008:50:35 and I want to get the data in CSV format. I specify the header Accept: text / csv. All OK. But I need a result with a different delimiter. How to tell the server that I want to receive CSV (for example) with the "|" delimiter ?

[laurenceisla]

Answered given on Gitter https://gitter.im/begriffs/postgrest?at=615b348e3f09d85736f4c04d:

There's no way to change the delimiter yet as mentioned in this issue: #1102. You could however get a similar behavior using a function with parameters working as your date filters, albeit in a more cumbersome way. A possible query for the function could be:

SELECT 'id|column1|column2|...'
UNION ALL
SELECT id + '|' + column1 + '|' + column2 + '|' + ... 
FROM api.goods 
WHERE updatetime > @updatetime

and use Accept: text/plain to get a plain text output.