| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: raw output from copy |
| Date: | 2015-04-15 20:06:40 |
| Message-ID: | 552EC4D0.3030908@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2015-04-15 20:11:43 | Re: raw output from copy |
| Previous Message | Simon Riggs | 2015-04-15 20:06:14 | Re: Turning off HOT/Cleanup sometimes |