great, thanks!
On Fri, Sep 15, 2017 at 1:28 AM, Sjoerd Mullender
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
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
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