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

Angelasweet hlfwmqd at gmail.com
Wed Jul 17 09:31:13 CEST 2013


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20130717/6b6dd06d/attachment.html>


More information about the users-list mailing list