Thanks, Rob. I realised that, so that's one advantage. But I am going to
do a feature request as I run a number of pre-defined queries everyday
and save to a csv file.
Regards
----------------------------------------
Mangesh
Desk: +44 20 3395 4159 Email: my...@st...
<mailto:%20M...@St...>
From: Robert Manning [mailto:rob...@gm...]
Sent: 09 November 2011 12:36
To: Yadav, Mangesh
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] Save query output to a file
On Wed, Nov 9, 2011 at 1:57 AM, Yadav, Mangesh <MY...@st...>
wrote:
Hi Rob,
Thanks. I downloaded the latest snapshot and can see sql2file.
However, what it simply does is what I would have done by right-click
and export. I would like to run the query in squirrel and directly send
the results to a file through the query. For example MySQL allows me the
below syntax to send the query result to a file on the local drive.
Well, it is not exactly the same in that it doesn't require you to run
the query inside of SQuirreL first before exporting (this can be
important for large data sets that exceed memory limits).
In any case, you can submit a feature request here:
http://sourceforge.net/tracker/?atid=393417&group_id=28383
Rob
|