No, MonetDB currently does not support binary copy into file.
You might want to file a feature request for this via http://bugs.monetdb.org/

Stefan

----- Original Message -----

> Thanks very much, it works!
>
> Still i want to know can i use COPY INTO FILE like "copy select *
> from
> sys.testtable into '/home/data1/file2'; "
> to copy into file in a binary form?
> because i want to use COPY BINARY INTO tablename, but i dont know how
> to
> write the result set of float and double binary into a file first.
>
> Meng
>
>
> 2013/7/17 Stefan Manegold <Stefan.Manegold@cwi.nl>
>
> > Indeed. Thanks! Fixed.
> >
> > ----- Original Message -----
> > >
> > > On 17.07.2013, at 08:04, Stefan Manegold <Stefan.Manegold@cwi.nl>
> > > wrote:
> > >
> > > > They should reside on the same file system as the database
> > > > farm"
> > > This one is actually a "must".
> > >
> > > Best
> > >
> > > Hannes
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > users-list mailing list
> > > users-list@monetdb.org
> > > http://mail.monetdb.org/mailman/listinfo/users-list
> > >
> >
> > --
> > | Stefan.Manegold@CWI.nl | DB Architectures   (DA) |
> > | www.CWI.nl/~manegold/  | Science Park 123 (L321) |
> > | +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |
> >
> > _______________________________________________
> > users-list mailing list
> > users-list@monetdb.org
> > http://mail.monetdb.org/mailman/listinfo/users-list
> >
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list
>

--
| Stefan.Manegold@CWI.nl | DB Architectures   (DA) |
| www.CWI.nl/~manegold/  | Science Park 123 (L321) |
| +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |

_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list