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 <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature