CODEWITHSUNDEEP
datagrip
redderblock
redderblock

Reputation: 157

DataGrip: script to export multiple queries to CSV needed

I would like to export 5 queries from 5 different databases to 5 local csv files. Best by only starting one script doing this.

In the old days in MS Access I used multiple "DoCmd.TransferSpreadsheet" for this in one VB script. Is there something similar in DataGrip?

use db1;
exportToCsv1(select * from...);
use db2;
exportToCsv2(select * from...);
...

Upvotes: 2

Views: 1283

Answers (1)

moscas
moscas

Reputation: 10335

In DataGrip, to export query result to CSV please use Execute to File from the context menu. enter image description here

The alternative way is to export the result itself.

enter image description here

Upvotes: 0

Related Questions