Hi Sjoerd,
Thanks a lot, it worked like a charm!
Anton
On Thu, Feb 11, 2016 at 12:47 PM, Sjoerd Mullender
Just use mclient.bat -u monetdb -d somedb -s "select * from sometable" > .\somefile.csv
You might want to add the -fcsv option as well to get csv output. And if you use -fcsv+, (that's a plus sign and a comma) you get comma-separated fields and a header line:
mclient.bat -fcsv+, -u monetdb -d somedb -s "select * from sometable" > somefile.csv
Also see [1].
[1] https://www.monetdb.org/Documentation/mclient-man-page
On 02/11/2016 09:25 PM, Anton Kravchenko wrote:
Hi there,
I wonder if one can copy a query result into stdout and redirect it to a file?
I've tried: mclient.bat -u monetdb -d somedb -s "copy select * from sometable into stdout" - > .\somefile.csv
But, only the table header is saved in somefile.csv...
P.S. 'select * from sometable' shows all data rows as expected. I am using MonetDB v11.21.11 (Jul2015-SP1) on Windows.
Thank you, Anton
_______________________________________________ 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