COPY BINARY to STDOUT

Поиск
Список
Период
Сортировка
От SAKAIDA Masaaki
Тема COPY BINARY to STDOUT
Дата
Msg-id 391A9411B4.51D8SAKAIDA@smtp.psn.ne.jp
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Patrick Welche
Дата:
Сообщение: Re: Patches list broken?
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: setproctitle() no longer used?