On Thu, Aug 6, 2009 at 2:42 PM, Martin Kersten
<Martin.Kersten@cwi.nl> wrote:
Hi Matthew
Matthew Jones wrote:
> I noticed that COPY...INTO from a file, when executed from a remote
> MonetDB mclient instance tries to load the file from the system that the
> database is actually running on rather than the system running the
> remote client.
Ofcourse. You sent a statement to a SQL server, it is interpreted in that context.
>
> Is this the expected behavior? Has anyone dealt with this or found
> another way to batch-load from a remote client?
you might use COPY FROM stdin in combination with
the mclient directive \<file - read input from file
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users