Postgres Pro
Downloads
Home   >   mailing lists

Re: psql and tab-delimited output - Mailing list pgsql-general

From Melvin Davidson
Subject Re: psql and tab-delimited output
Date
Msg-id CANu8Fiz276h-x90An_a-CjOdZwctTcM6mZGbsGfdQgz3OtWLfA@mail.gmail.com
Whole thread Raw
In response to psql and tab-delimited output  (Abelard Hoffman <abelardhoffman@gmail.com>)
Responses Re: psql and tab-delimited output
List pgsql-general
Tree view
>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
--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Sergey Burladyan
Date:
Subject: xlog min recovery request is past current point -- is it real problem?
Next
From: "Huang, Suya"
Date:
Subject: Re: Decreasing performance in table partitioning