Re: COPY BINARY to STDOUT

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)psn(dot)co(dot)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?