>> On Thu, Sep 7, 2017 at 3:28 PM <hamann(dot)w(at)t-online(dot)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
>>
Hi Manuel,
this works perfectly, many thanks
Wolfgang