COPY BINARY to STDOUT

From: SAKAIDA Masaaki <sakaida(at)psn(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: COPY BINARY to STDOUT
Date: 2000-05-11 11:05:53
Message-ID: 391A9411B4.51D8SAKAIDA@smtp.psn.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 '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

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2000-05-11 11:48:13 Re: setproctitle() no longer used?
Previous Message Patrick Welche 2000-05-11 10:53:15 Re: Patches list broken?