Re: [GENERAL] Piping CSV data to psql when executing COPY .. FROM STDIN (Solved)

2008-10-30 Thread Roberts, Jon
I am however unable to do the same successfully (the Java code simply hangs, probably as a result of the second psql not getting the input to it) from Java code using objects of ProcessBuilder and Process. I have used threads consume the STDOUT and STDERR streams (I write the STDOUT stream to

Re: [GENERAL] Piping CSV data to psql when executing COPY .. FROM STDIN (Solved)

2008-10-29 Thread Allan Kamau
Thanks Reid, Sam and others. Indeed the oversight was once again at my end. As rightfully pointed out I was using tab as a delimiter where the copy command COPY abc FROM STDIN WITH CSV HEADER expects a comma character and will ignore the first line. It does work appropriately when I pipe the

Re: [GENERAL] Piping CSV data to psql when executing COPY .. FROM STDIN (Solved)

2008-10-29 Thread Sam Mason
On Wed, Oct 29, 2008 at 12:11:43PM +0200, Allan Kamau wrote: I am however unable to do the same successfully (the Java code simply hangs, probably as a result of the second psql not getting the input to it) from Java code using objects of ProcessBuilder and Process. Why don't you use the