On 15/09/17 06:25, Anton Kravchenko wrote:
> Hi Sjoerd,
>
> Does MonetDB support BINARY BULK LOAD into a blob column? And if not, is
> there a reason?

Yes it does:

create table t (i int, b blob, s clob);
copy 1 records into t from stdin;
10|0102030405060708090a0b0c0d0e0f|string
select * from t;

You can of course use different delimiters, copy from an external file, etc.

>
> Thanks,
> Anton
>
> On Sat, Jul 8, 2017 at 9:02 PM, Brian Hood <brianh6854@googlemail.com
> <mailto:brianh6854@googlemail.com>> wrote:
>
>     Hi Sjoerd,
>
>     Thank you for this is makes sense now.
>
>     However essentially to INSERT data into a BLOB you are going to have
>     convert the data before inserting it into database, which could be
>     expensive in compute time.
>
>     Regards,
>
>     Brian Hood
>
>     On Mon, Jun 26, 2017 at 9:19 AM, Sjoerd Mullender <sjoerd@acm.org
>     <mailto:sjoerd@acm.org>> wrote:
>
>         On 24/06/17 21:31, Brian Hood wrote:
>         > Hi Guys,
>         >
>         > I don't seem to be able to INSERT into a blob field is there any
>         > information how to achieve this.
>         >
>         > Regards,
>         >
>         > Brian Hood
>         > _______________________________________________
>         > users-list mailing list
>         > users-list@monetdb.org <mailto:users-list@monetdb.org>
>         > https://www.monetdb.org/mailman/listinfo/users-list
>         <https://www.monetdb.org/mailman/listinfo/users-list>
>         >
>
>         Normally that would be something like:
>         INSERT INTO t VALUES ('0102030405060708090a0b0c0d0e0f');
>         where the value being inserted is no more than a list of hexadecimal
>         digits with en even length (two digits per octet).
>
>         --
>         Sjoerd Mullender
>
>
>         _______________________________________________
>         users-list mailing list
>         users-list@monetdb.org <mailto:users-list@monetdb.org>
>         https://www.monetdb.org/mailman/listinfo/users-list
>         <https://www.monetdb.org/mailman/listinfo/users-list>
>
>
>
>     _______________________________________________
>     users-list mailing list
>     users-list@monetdb.org <mailto:users-list@monetdb.org>
>     https://www.monetdb.org/mailman/listinfo/users-list

>     <https://www.monetdb.org/mailman/listinfo/users-list>
>
>
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>

--
Sjoerd Mullender


_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list