Export Data From Database Query Browser
G
Gavin Lowe
Export data from Database Query Browser in the same way that you can "Export to CSV" from the Named Query "Testing" tab.
Currently, if I retrieve data using an adhoc query, and I decide I should save and use it elsewhere, I have to set up a temporary Named Query to re-retrieve the data so that I can export it.
I can highlight all cells and Copy/Paste into Excel, but it does not copy the column names.
Log In
K
Kaitlin Blanchard
Hi Gavin,
I also wish this were an option! Depending on how crucially you need the data exported, maybe this workaround is worth it:
1) Run the query you'd like to export and save as a temporary table.
2) Run this query to get your column names:
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'Temporary Table Name'
ORDER BY Ordinal_Position
Then, copy and paste-transposed into Excel to get a row of column names.
3) Copy and paste the cells you are able to select, as you described in your original post.
Does this help? Honestly, your original solution of temp named query might be easier...