| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Jim Garrison <jim(dot)garrison(at)nwea(dot)org> |
| Cc: | PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Using statement parameters with Copy API? |
| Date: | 2013-09-12 04:13:39 |
| Message-ID: | alpine.BSO.2.03.1309120004460.15738@ejurka.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Wed, 11 Sep 2013, Jim Garrison wrote:
>
> I want to use the copy API to execute a parameterized query, as in
>
> COPY (SELECT * FROM TABLE WHERE KEY=?) TO STDOUT FORMAT BINARY
>
> As far as I can tell it is not currently possible to prepare this statement
> and pass it to the copy API.
>
This is a limitation of the server. It doesn't accept parameterized COPY
statements so the JDBC driver doesn't have a way to pass such a statement.
Perhaps the driver could perform the text interpolation itself as it does
in the V2 protocol, but that would also complicate the API if you wanted
to have something similar to PreparedStatement.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Garrison | 2013-09-12 19:07:35 | Using CopyManager with pooled JCA connection |
| Previous Message | Dave Cramer | 2013-09-11 17:52:05 | Re: CopyManager API? |