CODEWITHSUNDEEP
sqlselectdbeaver
Hambone
Hambone

Reputation: 16397

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.

Upvotes: 9

Views: 7029

Answers (2)

azmrtwo
azmrtwo

Reputation: 49

I was having the same problem. I found that I had to remove the schema from the table.

For example this doesn't work:

SELECT t.* Ctrl + Space FROM mySchema.table1 t

But these do work:

SELECT * Ctrl + Space FROM table1
SELECT t.* Ctrl + Space FROM table1 t

Upvotes: 0

Anepicpastry
Anepicpastry

Reputation: 542

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.

Upvotes: 9

Related Questions