> 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
> strea
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 J
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
Allan Kamau wrote:
Reid Thompson wrote:
Allan Kamau wrote:
Sam, I have been unable to understand your shell script well enough
to use it. Seems am slow this afternoon :-)
On this list I saw a message detailing using copy as illustrated
below (see )when I run this command I get the following
On Tue, Oct 28, 2008 at 03:11:05PM +0200, Allan Kamau wrote:
> Sam, I have been unable to understand your shell script well enough to
> use it. Seems am slow this afternoon :-)
Don't worry, I've just spent an hour going through three computers
trying to figure out why they didn't work. In the en
Allan Kamau wrote:
Sam, I have been unable to understand your shell script well enough to
use it. Seems am slow this afternoon :-)
On this list I saw a message detailing using copy as illustrated below
(see )when I run this command I get the following output (see
)
COPY abc FROM STDIN WIT
Reid Thompson wrote:
Allan Kamau wrote:
Sam, I have been unable to understand your shell script well enough
to use it. Seems am slow this afternoon :-)
On this list I saw a message detailing using copy as illustrated
below (see )when I run this command I get the following output
(see )
C
Sam, I have been unable to understand your shell script well enough to
use it. Seems am slow this afternoon :-)
On this list I saw a message detailing using copy as illustrated below
(see )when I run this command I get the following output (see
)
COPY abc FROM STDIN WITH CSV HEADER;
\.
1
On Tue, Oct 28, 2008 at 01:25:00PM +0200, Allan Kamau wrote:
> The alternative I am attempting is to use "COPY abc FROM STDIN WITH
> HEADER". I pipe the contents of the CSV file on my PC to the psql
> command (that connects to the remote PC) while issuing this copy command.
> This does seems not
Hi all,
I am trying to copy data (results of a SELECT * FROM abc WHERE ...) to a
remote PC (on my network).
If I execute the "COPY abc2 FROM abc.txt CSV WITH HEADER" on psql
connected to the remote PC, PostgreSQL will expect the file to be
resident on the (remote) server's file system (or atl
10 matches
Mail list logo
