#563 Paginated Export

[Mageddo]

Currently a cannot export all Select results without load it in the squirrel result table, for example:

My Limit Row is setted to 100

I have a users table

table users (
    creation datetime not null
)

counting the results

select count(1) from users where creation > sysdate - 30;
900,000

Exporting the results

select * from users where creation > sysdate - 30;

It will get 100 results only, then I do right click at the results table and click to export, whatever combination I do, my csv exported file for example will always have almost 100 results. I wanna that Squirrel export keep going in the pagination and do the export without I have to load it in my table results because is impossible to load 900,000 results in the GUI.

• Have SQuirrel this feature?
• Is this feature in your backlog?

[Mageddo]

Please close this issue, this feature was already developed.

Execute a SELECT, eg.

select * from users where creation > sysdate - 30

Go to Session -> Scripts -> Store result of SQL in file -> ajust your output format preferences then just click ok

it will result all select results not limited by the Limit rows feature. My squirrel version: snapshot-20171121_2249 and you must have the sqlscript plugin

thank you

[Gerd Wagner]

Closed as Mageddo requested.