>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 ' ';query returned copy data:id replace1 test\tvalue2 test\tvalue3 test\tvalue* -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.