>> On Thu, Sep 7, 2017 at 3:28 PM <hamann.w@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
>>
Hi Manuel,
this works perfectly, many thanks
Wolfgang
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general