Skip site navigation (1) Skip section navigation (2)

Re: COPY support in JDBC driver?

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Kris Jurka *EXTERN*" <books(at)ejurka(dot)com>,"Daniel Migowski" <dmigowski(at)ikoffice(dot)de>
Cc: "Michael Nacos" <m(dot)nacos(at)gmail(dot)com>,<pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: COPY support in JDBC driver?
Date: 2008-09-25 06:53:43
Message-ID: D960CB61B694CF459DCFB4B0128514C2028AA603@exadv11.host.magwien.gv.at (view raw or flat)
Thread:
Lists: pgsql-jdbc
Kris Jurka wrote:

> Yes, the current copy patches only support *Stream which does leave the 
> user exposed to encoding issues.  Providing a Reader/Writer API doesn't 
> support COPY ... BINARY, but I don't know how many people would actually 
> use such a thing.  Parallel interfaces are a possibility, but I'd guess 
> people would end up using the Stream versions for non-binary data anyway.
> 
> Does anyone have the need to do COPY BINARY?

I have never felt the temptation.

As far as I understand, that would mean that your code is dependent
on the endianness of the server machine and compile time flags like
--enable-integer-datetime.

> I also wonder what the encoding conversion hit is if no conversion needs 
> to be done.  Perhaps we should measure that before abandonding the Stream 
> API?

That would certainly be interesting, although I don't think it's a killer
argument.

I don't want to go on about Java, but I guess that if you need to load
huge amounts of data into a database as fast as possible, you would probably
not do this via JDBC from a remote machine, but use psql locally on the server.
So performance is of course important, but not the most important thing for me
when I code Java.

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.

Yours,
Laurenz Albe

In response to

Responses

pgsql-jdbc by date

Next:From: Craig RingerDate: 2008-09-25 07:05:39
Subject: Re: COPY support in JDBC driver?
Previous:From: Oliver JowettDate: 2008-09-25 06:44:24
Subject: Re: very large result sets and ResultSet.relative() to jump to a desired offset

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group