On Wed, Jun 27, 2007 at 10:32:32AM -0400, Jaime Silvela wrote: > I've been looking around for this functionality: > Is it possible to use COPY with a file that doesn't reside in the DB's > filesystem? I know there is sort of a solution in using COPY from stdin/ > COPY to stdout, however that depends on calling the psql command, which > breaks the flow of control of the programs I'm trying to write. Sorry? Copy to stdout/from stdin can be done by normal programs also, not just psql. Execute the command and then use putline/getline to transfer the data. In perl DBI is works like that, for C also, so probably from ruby also. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
