failed to open file when 'copy binary into table from binaryformfile'

Angelasweet hlfwmqd at gmail.com
Wed Jul 17 10:02:38 CEST 2013


then when i want to COPY BINARY INTO table, how to write to float into a
file in the binary form first?


2013/7/17 Stefan Manegold <Stefan.Manegold at cwi.nl>

> 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 at cwi.nl>
> >
> > > Indeed. Thanks! Fixed.
> > >
> > > ----- Original Message -----
> > > >
> > > > On 17.07.2013, at 08:04, Stefan Manegold <Stefan.Manegold at 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 at monetdb.org
> > > > http://mail.monetdb.org/mailman/listinfo/users-list
> > > >
> > >
> > > --
> > > | Stefan.Manegold at 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 at monetdb.org
> > > http://mail.monetdb.org/mailman/listinfo/users-list
> > >
> >
> > _______________________________________________
> > users-list mailing list
> > users-list at monetdb.org
> > http://mail.monetdb.org/mailman/listinfo/users-list
> >
>
> --
> | Stefan.Manegold at 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 at monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20130717/800d72ad/attachment.html>


More information about the users-list mailing list