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

Re: Simple (hopefully) throughput question?

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Simple (hopefully) throughput question?
Date: 2010-11-04 15:13:03
Message-ID: AANLkTinFxGBtdS-9_0-Y6UBB6+++A_bWhZfk6MQhBjEO@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
> JDBC driver has some COPY support, but I don't remember details. You'd
> better ask in JDBC list.

As long as we're here: yes, the JDBC driver has COPY support as of
8.4(?) via the CopyManager PostgreSQL-specific API. You can call
((PGConnection)conn).getCopyManager() and do either push- or
pull-based COPY IN or OUT. We've been using it for several years and
it works like a charm. For more details, ask the JDBC list or check
out the docs: http://jdbc.postgresql.org/documentation/publicapi/index.html

---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com

In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2010-11-04 15:24:05
Subject: Re: [PERFORM] typoed column name, but postgres didn't grump
Previous:From: Nick MathesonDate: 2010-11-04 15:08:42
Subject: Re: Simple (hopefully) throughput question?

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