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

Re: Using a COPY...FROM through JDBC?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Steve Wampler <swampler(at)noao(dot)edu>
Cc: Postgres-JDBC <pgsql-jdbc(at)postgresql(dot)org>,Postgres-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Using a COPY...FROM through JDBC?
Date: 2004-06-07 09:26:38
Message-ID: Pine.BSO.4.56.0406070250280.29634@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-performance

On Sat, 5 Jun 2004, Steve Wampler wrote:

> 
> [I want to use copy from JDBC]
> 

I made a patch to the driver to support COPY as a PG extension.  The
patch required properly encoded and formatted copy data available
from an InputStream.  Following some feedback from others I began adding
the ability to handle different encodings and the ability to read and
write objects without requiring any knowledge of the copy data format.  I
got hung up on the object read/write part because of some issues with how
type conversions are done in the driver.

At the moment there is a big push being made by Oliver Jowett to get true 
V3 protocol support implemented which is currently my highest priority.  
Getting copy support into the JDBC driver is something I'd like to see for 
7.5, but I couldn't say if that will happen or how complete it may be.  
Depending on your needs perhaps the initial patch is sufficient.

http://archives.postgresql.org/pgsql-jdbc/2003-12/msg00186.php

Kris Jurka


In response to

Responses

pgsql-performance by date

Next:From: StefDate: 2004-06-07 11:34:15
Subject: Postgres function use makes machine crash.
Previous:From: Markus SchaberDate: 2004-06-07 07:47:58
Subject: Re: Using a COPY...FROM through JDBC?

pgsql-jdbc by date

Next:From: salvatoreDate: 2004-06-07 10:56:07
Subject: Error JDBC
Previous:From: Kris JurkaDate: 2004-06-07 07:50:21
Subject: Re: Forcing use of cursor for large result sets

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