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

Re: Inserting 'large' amounts of data

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: Mario Splivalo <mario(dot)splivalo(at)megafon(dot)hr>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Inserting 'large' amounts of data
Date: 2009-08-26 17:34:32
Message-ID: 895e58dd0908261034y3887469agd8fdc62918f6be50@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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(at)truviso(dot)com
www.truviso.com

In response to

pgsql-jdbc by date

Next:From: Mario SplivaloDate: 2009-08-26 22:25:56
Subject: Re: Inserting 'large' amounts of data
Previous:From: dmpDate: 2009-08-26 17:28:42
Subject: Re: Inserting 'large' amounts of data

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