Re: raw output from copy - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: raw output from copy
Date
Msg-id 552EC4D0.3030908@gmx.net
Whole thread Raw
In response to Re: raw output from copy  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: raw output from copy
List pgsql-hackers
On 4/10/15 5:26 PM, Pavel Stehule wrote:
> Hi
> 
> I wrote a prototype of this patch, and it works well
> 
> postgres=# set client_encoding to 'latin2';
> SET
> Time: 1.488 ms
> postgres=# \copy (select xmlelement(name xx, d) from d) to ~/d.xml
> (format 'raw')
> COPY 1
> Time: 1.108 ms
> postgres=# copy (select xmlelement(name xx, d) from d) to stdout (format
> 'raw') ;
> <?xml version="1.0" encoding="LATIN2"?><xx>příliš žluťoučký
> kůň</xx>Time: 1.000 ms

I think you can get the same thing using regular psql output and just
turning off all field and record separators and tuple headers and so on.




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Turning off HOT/Cleanup sometimes
Next
From: Simon Riggs
Date:
Subject: Re: Turning off HOT/Cleanup sometimes