From: | Pavel Golub <pavel(at)microolap(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, 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-07-01 06:42:00 |
Message-ID: | CAEu9NuhbT76stU7gU-0vsZxfSeebUCPPcm+B4_2ueFgTKgTaBw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello Pavel.
I looked through the patch. Sources are OK. However I didn't find any docs
and test cases. Would you please provide me with short description on this
feature and why it is important. Because I didn't manage to find the old
Andrew Dunstan's post either.
On Sat, Apr 11, 2015 at 12:26 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
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
>
> 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
>>
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>
--
Nullus est in vitae sensus ipsa vera est sensus.
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Langote | 2015-07-01 06:46:05 | Re: Parallel Seq Scan |
Previous Message | Michael Paquier | 2015-07-01 06:21:56 | Re: Bug in bttext_abbrev_convert() |