Copy multiple values from single column in grid

dstnrgrs's profile image dstnrgrs posted 3 years ago in General Permalink

I'm a new PostgreSQL user and was not a fan of pgAdmin. I just found HeidiSQL and am trying it out, but have a few questions:

Is there a way to select and copy a range of values from an individual column in the grid? I see the right-click 'Copy selected rows' option, but I'm looking for a way to select what's highlighted/selected in the grid.

Also, I found another post that said that the number format is based on region settings configurable in the Control Panel (windows 10). I adjusted the number format to not use a comma separator, and then restarted HeidiSQL, but my grid still shows the comma separators in numbers. Any suggestions?

ansgar's profile image ansgar posted 3 years ago Permalink

Copying multiple values from one of many columns in HeidiSQL's grid is not doable out-of-the-box. You will need to deselect unwanted columns first, and then click that "Copy selected rows" item:

Description

For that regional setting, you may need to log off and on to your Windows to make it effective. To be honest I never did that on Win10. But please shout if that also does not help.

However, it's easier to tell Heidi not to format numbers locally, in Tools > Preferences > Grid formatting:

Description

dstnrgrs's profile image dstnrgrs posted 3 years ago Permalink

Thanks. Unchecking the local number format worked for me.

Regarding unselecting the columns, I see that can be done when viewing the data for a single table, but I'm not seeing that when running a custom query. I've got some fairly complex queries that I occasionally need a range of values. Changing the query to only use the columns I need can affect the results due to joins on various tables. Is there a way to filter the columns of a query grid?

Please login to leave a reply, or register at first.