On Thu, Sep 7, 2017 at 3:28 PM <haman...@t-online.de> wrote: > Example query > select a.col1, case when a.col2 > 0 then a.col3 else b.xcol1 end as mycol3 > from a left join b on .... > Expected response > col1 mycol3 >
This may be overkill, but works: postgres=# \copy (select 1 as foo, 2 as bar limit 0) to stdout with (format csv, header, delimiter ' ') foo bar