On Sun, Sep 7, 2014 at 5:17 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:
>the output I'd prefer is:
> id fld_1
> 1 test\tvalue
> 2 test\tvalue
> 3 >test\tvalue
Does this work for you?
copy (SELECT id, replace(fld_1, ' ', '\t') FROM tsv_test) to stdout with csv header delimiter ' ';
Thank you, Melvin. Yes, I think that's what I'll do for the time-being, until COPY's TSV format supports HEADER.
