Re: COPY to/from non-local file

[Martijn van Oosterhout <kleptog(at)svana(dot)org>]

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(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature