Re: raw output from copy

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: raw output from copy
Дата
Msg-id CAFj8pRDn9kHPsq1EWm5-zikJOYy2TjOOp-b0cXMcX1Dt3pPwfA@mail.gmail.com
обсуждение исходный текст
Ответ на raw output from copy  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: raw output from copy  (Peter Eisentraut <peter_e@gmx.net>)
Re: raw output from copy  (Pavel Golub <pavel@microolap.com>)
Список pgsql-hackers
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.stehule@gmail.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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Petr Jelinek
Дата:
Сообщение: Re: TABLESAMPLE patch
Следующее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: Doubt about AccessExclusiveLock in ALTER TABLE .. SET ( .. );