Re: COPY to/from non-local file

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