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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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