Re: psql and tab-delimited output
>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 replace
1 test\tvalue
2 test\tvalue
3 test\tvalue
--
> 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 replace
1 test\tvalue
2 test\tvalue
3 test\tvalue
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
В списке pgsql-general по дате отправления:
Предыдущее
От: Sergey BurladyanДата:
Сообщение: xlog min recovery request is past current point -- is it real problem?