Page 1 of 1

[DONE] Copy all data with header names

PostPosted: Mon Aug 13, 2012 7:41 pm
by sbeca
I very frequently have to copy the result of a query to a spreadsheet.

I can use ctrl-a and select and copy it all but:

1. The column names are not copied
This can be painful to retype if you have too many columns.

2. Only visible data is copied, but not all that is in the query.

It would be great if you could add these features, of "optionally copying data with headers" (I believe Aqua Data Studio allows this) and also copying the whole query data set.

Thanks!
Sebastian

Re: Copy all data with header names

PostPosted: Tue Aug 14, 2012 8:56 am
by EugeneJF
Try to use Resultset Export feature. I think it's you are asked about. :)

Re: Copy all data with header names

PostPosted: Tue Aug 14, 2012 1:12 pm
by fallingdown
I believe Crtl+Shift+C will copy with headers. I think you have to do the result export to get all the data if it's more than the initial number of rows.

Re: Copy all data with header names

PostPosted: Wed Aug 29, 2012 6:42 pm
by sbeca
WOW, Ctrl-Shit-C DOES WORK!! Thank you!

Still, regarding the results export, where is that option?

Re: Copy all data with header names

PostPosted: Thu Aug 30, 2012 8:42 am
by EugeneJF