we often use squirrel to export the result of a query to Excel or CSV. But in order to export the results, we first need to display them.
With large datasets this can lead to memory problems (insufficient java heap space).

As far as I know I cannot write a query and then pipe the query results directly into a file.
But I think this would be a very useful option and could possibly prevent these memory problems.

P.S. I know I can configure squirrel to use more heap space, but this is not always sufficient.

Tilmann Brenk

Kaimer GmbH & Co. Holding KG
Kommanditgesellschaft mit Sitz in Essen · Amtsgericht Essen · HRA 6843

Kaimer GmbH · Geschäftsführer: Bernd Kaimer, Frank Schrick
Amtsgericht Essen · HRB 13343