Re: [MonetDB-users] COPY command syntax

I had trouble with the delimiters as well. I ended up finding a message on the mailing list a while back that had the right syntax. Here's my command that works: COPY 1000000 RECORDS INTO test.aggregated_detail_data_2009 FROM '/home/monetdb/aggregated_detail_data_2009_1.csv' using delimiters ',','\n'; On Thu, Oct 29, 2009 at 3:36 PM, Roman Sokolyuk wrote:

I tried running the command following your example and I think I am still doing something wrong:

sql>COPY 110301 RECORDS INTO my_table FROM ('C:\MyFile.csv') DELIMITERS ',', '\n', ''''; !Cannot pass number of records in Binary COPY INTO in: "copy 110301 records into my_table from ('C:\MyFile.csv')" !syntax error, unexpected DELIMITERS in: "delimiters"

On Wed, Oct 28, 2009 at 7:19 PM, Roman Sokolyuk wrote:

...

Thanks!!!

On Wed, Oct 28, 2009 at 6:23 PM, Stefan de Konink wrote:

...

On Wed, 28 Oct 2009, Roman Sokolyuk wrote:

...

Could someone please point out to me what is wrong with the way I am using the COPY utility?

I can give you a working example:

http://mirror.openstreetmap.nl/rivm/stations.sql

Stefan

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users