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