Scripting data export
已回答
In DBVisualizer, you can write simple scripts to export data to files from queries. I'm wondering if this is possible with DataGrip.
Here's an example of export that you can do with DBVisualizer - a script that exports the results of two queries to two different files. When the script is run, it prompts for the value of $(date) the same as if it was a parameter within a SQL query:
@export on;
@export set filename = "D:\report_1_$(date).csv"
select a,b,c from t1;
@export set filename = "D:\report_2_$(date).xlsx"
select d,e,f from t2;
@export off;
请先登录再写评论。
I've created feature request on our tracker, please follow and vote to get noticed on any updates.