From: | "Christoph Schlarmann" <cschlarm(at)abashh(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | copy from stdin blocks? |
Date: | 2002-04-23 19:09:32 |
Message-ID: | 000901c1eafa$66e39900$3604010a@abashh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi out there,
I've got the following problem with postgresql 7.1.3 (linux Kernel
2.2.16-SMP and Kernel 2.4.16, bash):
I tried to copy data from stdin to postgresql in a pipe. If the data size
exeeds the size of the stdin buffer, the process doesn't return.
simplified example (copy from file works fine, but my intention is to copy
from stdin):
cat data_file | psql database -c "copy table from stdin delimiters ';' with
null as '';"
With a small amount of data everything works fine. I'm a little bit confused
because I didn't find any hints concerning this problem surfing the net and
due to the character of the problem it should be a major problem. Did I miss
something ?
Any help is greatly appreciated,
Thanks
Christoph
From | Date | Subject | |
---|---|---|---|
Next Message | Shaun Grannis | 2002-04-23 19:16:46 | Performance Issues |
Previous Message | Cornelia Boenigk | 2002-04-23 18:56:12 | PostgreSQL and bytea |