Cop query results with headers
Answered
I'm switching from AquaData studio to DataGrip, but the biggest missing feature so far is a quick "copy results with header"
In Aqua a simple cmd-W would copy with headers and I could dump my results in an excel file and pass them onto someone else to view.
In data-grip the only solution I see is to dump to a file, which is a lot clicking and typing and opening files. I'm sure this is possible with a single keyboard shortcut, what am I missing?
Thanks
Please sign in to leave a comment.
Hi,
You can dump your results to csv file with headers and import to excel.
As for shortcut we're missing it.
Thank you.
Can you please please please add headers to the clipboard copy as a new feature to a soon release? It saves me so many minutes per day to just copy to the clipboard instead of dumping to files and opening the files elsewhere.
Thanks!!
The way we have to deal with this now it to choose download to the csv, click headers and format the csv, and then select and copy the query results from the preview window.
It would be nice to not click the header checkbox every time, and it would be nice to have less steps.
Sorry to bump this - I've just started using DG and a "right-click->copy with headers" is the main thing missing in my workflow. Is this on the horizon to be added?
Thanks,
Phil
One needs to configure custom CSV format:
and then in a query result, one can choose it once:
and copy results: