Postgres Pro
Downloads
Home   >   mailing lists

Re: Inserting 'large' amounts of data - Mailing list pgsql-jdbc

From Maciek Sakrejda
Subject Re: Inserting 'large' amounts of data
Date
Msg-id 895e58dd0908261034y3887469agd8fdc62918f6be50@mail.gmail.com
Whole thread Raw
In response to Inserting 'large' amounts of data  (Mario Splivalo <mario.splivalo@megafon.hr>)
List pgsql-jdbc
Tree view 
Right. As of the 8.4 release, you have a jdbc API to the postgresql
COPY functionality. Cast your Connection to a PGConnection and call
.getCopyAPI(). You can then use the CopyManager[1] to copy data in
from your tomcat servlet.

[1] http://jdbc.postgresql.org/documentation/publicapi/org/postgresql/copy/CopyManager.html

--
Maciek Sakrejda | Software Engineer | Truviso
(650) 242-3500 Main
(650) 242-3501 F
msakrejda@truviso.com
www.truviso.com

pgsql-jdbc by date:

Previous
From: John R Pierce
Date:
Subject: Re: Inserting 'large' amounts of data
Next
From: dmp
Date:
Subject: Re: Inserting 'large' amounts of data