On Thu, Jul 31, 2008 at 04:10:06AM -0700, ashokguruswamy wrote:

my seasonal compliments..

this is ashok. i am using monetdb for my application with java. just i need to copy the monetdb table to a csv file..

in an sql manual i read the syntax for copying from table to csvfile is

Syntax:

COPY <subquery> INTO [ [USING] DELIMITERS tuple_separator [’,’ record_separator [ ’,’ string_quote ]]] [ NULL AS null_string ];

Operating System: Windows XP

My query:

copy select * from table_name into 'D:/file_name.csv' using delimiters '|';

This syntax and your query is correct and should work with both the latest release (MonetDB5.6/sql2.24) and current (ie CVS head). On the older versions it does not work. Niels

but if i execute this, am facing the following problem.. any suggestion? asap...

Error: Syntax error, unexpected SELECT, expecting INTO in: “copy select”..

Also the query specified below which having --with null as 'null_String"-- is not working..

copy select * from table_name into 'D:/file_name.csv' using delimiters '|' with null as ' ';

I want a way to copy monetdb tables to csv files.. -- View this message in context: http://www.nabble.com/monetdb-copy-command-tp18752294p18752294.html Sent from the monetdb-users mailing list archive at Nabble.com.

------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

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