Postgres Pro
Downloads
Home   >   mailing lists

Thread: COPY BINARY to STDOUT

COPY BINARY to STDOUT

From
SAKAIDA Masaaki
Date:
Hi,
 When the next COPY command is specified, psql seems to stop 
proceeding. Nothing can be operated.

prompt> psql
postgres=# \h copy
Command:     COPY
Description: Copies data between files and tables
Syntax:
..(snip)..
COPY [ BINARY ] table [ WITH OIDS ]   TO { 'filename' | stdout }   [ [USING] DELIMITERS 'delimiter' ]   [ WITH NULL AS
'nullstring' ]
 

postgres=# copy test to stdout;
1       sakaida                 kobe
2       haru                    tokyo
3       nobu                    osaka

postgres=# copy binary test to '/tmp/test.dat';
COPY
postgres=# copy binary test to stdout;  <====== error???
....Nothing can be operated.....

 Of course, it isn't right to specify such a COPY command. 
However, an appropriate treatment seems to be necessary.

--
Regards,
SAKAIDA Masaaki  -- Osaka, Japan

Re: COPY BINARY to STDOUT

From
Bruce Momjian
Date:
Any comments on this?


> 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?
> 
>             regards, tom lane
> 


--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026

Re: COPY BINARY to STDOUT

From
Tom Lane
Date:
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?