Using statement parameters with Copy API? - Mailing list pgsql-jdbc

From Jim Garrison
Subject Using statement parameters with Copy API?
Date
Msg-id 0C723FEB5B4E5642B25B451BA57E27303EE01F7C@S1P5DAG3C.EXCHPROD.USA.NET
Whole thread Raw
Responses Re: Using statement parameters with Copy API?  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

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.

 

Is there a way to accomplish this other than just building the SQL with values already substituted?

pgsql-jdbc by date:

Previous
From: Jim Garrison
Date:
Subject: Re: CopyManager API?
Next
From: Dave Cramer
Date:
Subject: Re: CopyManager API?