squirrel-sql-users

[Squirrel-sql-users] Redirect query result output to a file instead of table

[Timm B. <tba...@gm...>]

Hi,

Is there a way to redirect the output to a file (for example tab
delimited) and not show it in the result table?

I have queries which return many million rows and regardless what heap
space I allocate, it will not be enough to hold it in SquirreLSQL's
JTable.
Right now I have to use the database's client, but it would be great
if I could do it right out of Squirrel.

Thanks,
Timm

Re: [Squirrel-sql-users] Redirect query result output to a file instead of table

[Stefan W. <ste...@ao...>]

Hi Tim,

we have finished a feature called "Store result of SQL in file".

This is available via the menu (Session => Scripts => Store result of 
SQL in file) or the tools pop-up (hit Strg+T, then type sql2file). The 
aim of this feature is to export the result of a SQL directly into a 
file, without using huge memory.

For the usage of this feature, please have a look at our help about the 
SQL Script Plugin.

Here are the interesting part of the help:

    * /You may export the result of the currently selected SQL Select
      statement directly into a file. To do so, select a SQL Select
      statement in the SQL editor and hit the ctrl + t shortcut to open
      the tools pop-up. Then choose the sql2file function from the
      pop-up. Alternative, you can do this via the menu entry Session =>
      Scripts => Store result of SQL in file/

    * /After this, the control dialog appears. This dialog give you the
      control about target, type and data format. Be careful, if you
      decide to export the data into the MS Excel format. In this case,
      the result is build in memory and SQuirreL SQL may run out of memory./

    * /The export is done on a new database connection, so the user can
      continue using SQuirreL SQL while exporting the data. A progress
      monitor show the progress of the export and you can cancel it any
      time. If the export if done, the progress dialog disappears./


Please note, that this is only available at the current SNAPSHOT release.

I hope, this is what you like.

Stefan

Am 2011-10-17 17:52, schrieb Timm Baumeister:
> Hi,
>
> Is there a way to redirect the output to a file (for example tab
> delimited) and not show it in the result table?
>
> I have queries which return many million rows and regardless what heap
> space I allocate, it will not be enough to hold it in SquirreLSQL's
> JTable.
> Right now I have to use the database's client, but it would be great
> if I could do it right out of Squirrel.
>
> Thanks,
> Timm
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2d-oct
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>