Jean-Luc Lachance <[EMAIL PROTECTED]> writes:
> psql -c "COPY table FROM STDIN DELIMITERS ':'" < data.txt
> hangs without warning when supplied with more field than the actual
> table.
Oh?
$ psql regression
...
regression=# create table tab (f1 int,f2 int);
CREATE
regression=# \q
$ cat data.txt
1:2:3
4:5:6
$ psql -c "COPY tab FROM STDIN DELIMITERS ':'" regression <data.txt
NOTICE: copy: line 1, CopyReadNewline: extra fields ignored
NOTICE: copy: line 2, CopyReadNewline: extra fields ignored
$ psql regression
...
regression=# select * from tab;
f1 | f2
----+----
1 | 2
4 | 5
(2 rows)
regression=#
Looks fine from here ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
