Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Turn select * into individual field names in DBeaver

I stumbled upon one of the most amazing features in DBeaver, where I had:

select *
from foo

And I hit some key combination that turned * into an individual list of field names:

select field1, field2, field3, field4
from foo

The problem is I cannot repeat it, no matter what I try, and I can't find any documentation on the feature.

If anyone knows the key combination to make this work, please let me know.

like image 435
Hambone Avatar asked Oct 11 '18 20:10

Hambone


Video Answer


1 Answers

Lukasz is right.
After you type the asterisk *, hit Ctrl+Space and the intellisense window (SQL Assist) will appear with the field names from the table.

like image 197
Anepicpastry Avatar answered Oct 17 '22 09:10

Anepicpastry