COPY BINARY to STDOUT - Mailing list pgsql-hackers

From SAKAIDA Masaaki
Subject COPY BINARY to STDOUT
Date
Msg-id 391A9411B4.51D8SAKAIDA@smtp.psn.ne.jp
Whole thread Raw
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Patrick Welche
Date:
Subject: Re: Patches list broken?
Next
From: The Hermit Hacker
Date:
Subject: Re: setproctitle() no longer used?