Re: COPY support in JDBC driver?

From: "Ido M(dot) Tamir" <tamir(at)imp(dot)ac(dot)at>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: COPY support in JDBC driver?
Date: 2008-09-25 10:17:41
Message-ID: 200809251217.41257.tamir@imp.ac.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thursday 25 September 2008 09:05:39 Craig Ringer wrote:
> Albe Laurenz wrote:
> > For me the nice thing about COPY support in JDBC would be that you have
> > an easy way to load CSV files into the database or dump them out from a
> > database, which is a requirement I encounter frequently.

> It also permits you to do bulk load/dump operations within the context
> of an ongoing JDBC transaction. Somebody on this list (or -general; I
> don't remember) was trying to do that only a few days ago.

This was exactly something that I had to do once.
Thanks to java, I could even put a FilterInputStream to change the
input data before streaming it into the copyManager,

> Text-based COPY in the JDBC driver would be a significant plus to me. I
> can't say I personally care about binary COPY especially with a language
> that tries to be platform independent.
>

Yes please, it would be a great if this makes it into the
official driver and then onto the maven repositories.

thank you very much,
ido

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Nacos 2008-09-25 16:01:44 Re: Performance comparison to psql.
Previous Message Craig Ringer 2008-09-25 07:05:39 Re: COPY support in JDBC driver?