Re: COPY BINARY to STDOUT

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Any comments on this?

There is a test in there now to reject COPY BINARY TO STDOUT/FROM STDIN.
If anyone figures out how to support it, the test can be removed...
        regards, tom lane

>> SAKAIDA Masaaki <sakaida@psn.co.jp> writes:
>>>> postgres=# copy binary test to stdout;  <====== error???
>>>> [ psql gets confused ]
>> 
>> Yes, I see it too.  The COPY data protocol is fundamentally textual,
>> so there's no way of making this work without rewriting all our frontend
>> interface libraries.  Not worth it.  I suggest that the backend should
>> reject COPY BINARY commands that are either FROM STDIN or TO STDOUT.
>> Anybody see a better way?