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 'null string' ]

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



Thu, 11 May 2000 20:05:53 +0900
SAKAIDA Masaaki <sakaida@psn.co.jp>
COPY BINARY to STDOUT