Re: psql and tab-delimited output

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: Abelard Hoffman <abelardhoffman(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql and tab-delimited output
Date: 2014-09-08 00:17:52
Message-ID: CANu8Fiz276h-x90An_a-CjOdZwctTcM6mZGbsGfdQgz3OtWLfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Huang, Suya 2014-09-08 01:57:33 Re: Decreasing performance in table partitioning
Previous Message Sergey Burladyan 2014-09-07 22:21:39 xlog min recovery request is past current point -- is it real problem?