Re: psql COPY with JDBC - Mailing list pgsql-jdbc

From Guy Rouillier
Subject Re: psql COPY with JDBC
Date
Msg-id CC1CF380F4D70844B01D45982E671B230137A827@mtxexch01.add0.masergy.com
Whole thread Raw
In response to psql COPY with JDBC  ("Christopher Condit" <condit@sdsc.edu>)
List pgsql-jdbc
Christopher Condit wrote:
> Hi All-
> I've been trying over at the general postgres list with no luck, so I
> thought I'd try here.  I need to bulk load results from a Java
> application on one machine to a postgres db on a remote server.  I
> know I can use psql interactively to accomplish this, but I'd like to
> be able to do it programmatically: 1)       I noticed that there was
> a COPY patch floating around a couple of years ago - does this still
> exist.  If so, has it been updated for the latest JDBC driver? 2)
> Is there a better way to accomplish this than the above patch - with
> or without JDBC?

Well, since you are using a Java application, you are not limited to
COPY, correct?  You can generate whatever output format you want.  In
that case, you can generate INSERT statements, right?

--
Guy Rouillier

pgsql-jdbc by date:

Previous
From: "Nicholas E. Wakefield"
Date:
Subject: Re: Performance problem with timestamps in result sets
Next
From: "Christopher Condit"
Date:
Subject: Re: psql COPY with JDBC