| 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: | Whole Thread | Raw Message | 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
| 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? |