the ability to autocomplete the schema not only with tables, but also with functions and procedures

[detkliff]

Debeaver 24.0.3
Postgresql 14.3

Current version of Debeaver autocomplete tables and view only.

It would be very convenient to display a list of procedures and functions of the circuit in autocompletion. For example, the last block.
How does Oracle PlSQLDeveloper do this?

[E1izabeth]

DBeaver shows completion proposals for procedures and functions in SELECT and WHERE clauses, if this setting is turned on

Do you need a procedure in FROM clause?

[detkliff]

Do you need a procedure in FROM clause?

yes, i need.

[detkliff]

DBeaver shows completion proposals for procedures and functions in SELECT and WHERE clauses, if this setting is turned on

Do you need a procedure in FROM clause?

but your option works not well
step 1 wrong search

step 2 wrong search

step 3 ok

step 4 ok

[E1izabeth]

but your option works not well

It doesn't work with schema name, but works without it.

[detkliff]

but your option works not well

It doesn't work with schema name, but works without it.

It’s not at all clear which function it will call if there are functions with the same names and signatures in several schemas

[E1izabeth]

Yes, I agree with you. That's a point to improve autocompletion too.

[detkliff]

I had to disable this option. I don't understand how it works at all.

After disabling the option, it no longer works correctly

but I haven't specified the point after the table alias yet

if I choose the suggested option, the alias is replaced with the column name and the alias disappears

[detkliff]

what kind of list this is is not clear, it does not apply to either nsi_io or nsi_candidate

[E1izabeth]

Completion doesn't work well in subqueries now. We're working on improvements.