As you know, PostgreSQL does not allow executing select from database-A to some object in database-B, due to known limitation:
cross-database references are not implemented
That's why I suggest to do not show databases in a list of suggestions here (or at least, turn this option off in Preferences).
It can be benefitial for those:
who never writes queries with exclicitly defined database name before schema of the object
who has a lot of databases and don't want to see useless items in suggestion list because they can interfere with names of other objects with similar names
This is only about PostgreSQL-databases.
I expect other databases which support 'cross-database references' (for example, SQL Server) will still suggest the databases in suggestion list.
Matvey16
commented
2 months ago
Description
As you know, PostgreSQL does not allow executing select from database-A to some object in database-B, due to known limitation:
cross-database references are not implementedThat's why I suggest to do not show databases in a list of suggestions here (or at least, turn this option off in Preferences).
It can be benefitial for those:
This is only about PostgreSQL-databases. I expect other databases which support 'cross-database references' (for example, SQL Server) will still suggest the databases in suggestion list.
https://github.com/user-attachments/assets/7b525196-0451-43c5-a2a3-9721ba5181b6
DBeaver Version
Community Edition 24.1.5-202408122322
Operating System
Windows 10
Database and driver
PostgreSQL 16 PostgreSQL JDBC Driver 42.7.4
Steps to reproduce
No response
Additional context
No response