Re: raw output from copy

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

Regards

Pavel

2015-04-09 20:48 GMT+02:00 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:

> Hi
>
> This thread was finished without real work. I have a real use case -
> export XML doc in non utf8 encoding.
>
> http://www.postgresql.org/message-id/16174.1319228878@sss.pgh.pa.us
>
> I propose to implement new format option "RAW" like Tom proposed.
>
> It requires only one row, one column result - and result is just raw
> binary data without size.
>
> Objections? Ideas?
>
> Regards
>
> Pavel
>