OK - Now I see the COPY patch, adding the CopyManager class to the jdbc driver. This is exactly the functionality I'm looking for. Has anyone gotten this to work with the latest codebase? Is there a new patch available? Thanks for your help, Chris -----Original Message----- From: Tino Wildenhain [mailto:tino@xxxxxxxxxxxxx] Sent: Thursday, March 30, 2006 1:07 AM To: Christopher Condit Cc: pgsql-general Subject: Re: [GENERAL] pgsql and streams Christopher Condit schrieb: > Back to this thread - I realize that in the "COPY TO" documentation, it > states the CSV file used for loading must be on the server's disk. If I > can't put files on the server's disk, I'm curious if I can use the STDIN > option from my JDBC client to load the data to the server? Using psql I > can stream data after the call. Is there anyway to accomplish the same > thing with JDBC? > Not sure about JDBC but you can in fact stream your data to COPY via STDIN - which is the network socket of your database connection. I'm using this with python for example. Regards Tino
