Hi 2016-12-05 14:19 GMT+01:00 Kohei KaiGai <kai...@kaigai.gr.jp>:
> Sorry for my late response. > > I've briefly checked a series of discussion in the past. > I understood the target/purpose of this patch is provision of a fast > interface > to import/export a particular cell of a relation, by skip of text<->binary > transformation. Its typical use case are XML and JSON data types. Right? > There are more goals: 1. user friendly import of text or binary data - import text data (with psql) from file is possible - but you have to load a content to psql variable. For binary data you should to use workaround based on LO and transformation from LO to bytea. 2. user friendly export text or binary data - now, the binary data can be exported only via transformation to LO. The XML has very interesting features when is passing from/to client binary. This feature is impossible in psql now. > > If so, how about the idea to use fast-path invocation protocol to call > functions > to import/export these document types? > It allows to accept binary form of the data stream, with minimum overheads. > Sorry, I don't see a sense - for Fast API I have to write a application - and then I can write a application with support of binary passing. > > It seems to me extend of COPY statement for this optimization is a bit > overkill > solution. Do we find out an alternative solution that we can build on > the existing > infrastructure? > The advantage and sense of COPY RAW was reusing existing interface. The question was: How I can export/import binary data simply from psql console? Regards Pavel > > Best regards, > > 2016-12-05 14:16 GMT+09:00 Haribabu Kommi <kommi.harib...@gmail.com>: > > > > > > On Tue, Nov 22, 2016 at 10:48 PM, Haribabu Kommi < > kommi.harib...@gmail.com> > > wrote: > >> > >> Hi, > >> > >> This is a gentle reminder. > >> > >> you assigned as reviewer to the current patch in the 11-2016 commitfest. > >> But you haven't shared your review yet. Please share your review about > >> the patch. This will help us in smoother operation of commitfest. > >> > >> Please Ignore if you already shared your review. > > > > > > Patch is not applying properly to HEAD. > > Moved to next CF with "waiting on author" status. > > > > > > Regards, > > Hari Babu > > Fujitsu Australia > > > > -- > KaiGai Kohei <kai...@kaigai.gr.jp> >