Export large csv files

[Michael McAuley]

Hi,
I would like to be able to export tables in csv or ~ values. I experience out of memory problem when I try to view to contents of the entire table. The table has apprx 1.5 million rows. Can this be done without viewing the tables?

 

[Marco Kalter]

Yes. If you enter the query in the SQL Window, and press the "Export Query Results" button, the results will directly be written to the file without any memory overhead.

 

[Michael McAuley]

where is this button? Are you refering to the right click on grid --> export button? If so - that only gets the data that is currently on screen i.e. brought back by the query.

 

[Michael McAuley]

I think i figured it out. It must be the button that looks like a cylinder and a disk, underneath the prev/next arrow buttons.

 

[Marco Kalter]

That's the one