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 <file_name> [ [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