[Monetdb-developers] [Monetdb-checkins] load data from a file to a table

Niels Nes Niels.Nes at cwi.nl
Wed Jun 24 16:01:22 CEST 2009


On Tue, Jun 16, 2009 at 02:54:01PM +0000, Pedro Bramao wrote:
> I'm trying to load data into a table from a file, named criminoso.sql,
> to a table named criminos stored in MonetDB.
> I'm doing the following coomand :
> 
> copy 2 records into criminoso from '/home/pedro/Escola/tabd/
> criminoso1.sql' using delimiters tuple_separator ',' record_separator
> ';';

Try

copy 2 records into criminoso from '/home/pedro/Escola/tabd/criminoso1.sql' using delimiters ',',';';

Niels
> 
> But it's not working... i nedd some help!!!!
> 
> thanks
> 
> ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
> Novo Internet Explorer 8: mais rápido e muito mais seguro. Baixe agora,
> é grátis!

> ------------------------------------------------------------------------------

> _______________________________________________
> Monetdb-checkins mailing list
> Monetdb-checkins at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-checkins


-- 
Niels Nes, Centre for Mathematics and Computer Science (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room C0.02/M3.46,  phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl


More information about the developers-list mailing list