Postgres Pro
Downloads
Home   >   mailing lists

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

From Abelard Hoffman
Subject Re: psql and tab-delimited output
Date
Msg-id CACEJHMgEXgL_qXRCfJ9X0CwdUTb1WhkrrEx8QyVmrOoJbQrtLQ@mail.gmail.com
Whole thread Raw
In response to Re: psql and tab-delimited output  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
On Sun, Sep 7, 2014 at 5:17 PM, Melvin Davidson <melvin6925@gmail.com> 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.


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Querying a time range across multiple partitions
Next
From: Adrian Klaver
Date:
Subject: Re: Issue with to_timestamp function