search

qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
https://qgis.org
GNU General Public License v2.0
10.43k stars 2.98k forks source link

Show PostgreSQL- Foreign Table in DB-Manager project tree #28018

Open qgib opened 5 years ago

qgib commented 5 years ago

Author Name: Max Bohnet (Max Bohnet) Original Redmine Issue: 20197

Redmine category:db_manager

The DB-Manager for PostGIS does not show Foreign Tables in a PostGIS database schema. Normal Tables, Views and Materialized Views are shown, but Foreign Tables are ignored.

However, i can load the Foreign Table into QGIS using the SQL-Window - tab and loading it using

SELECT * FROM myschema.my_foreign_table

It would be nice if the DB-Manager could show Foreign Tables in the project tree.

rhurlin commented 4 years ago

Shouldn't this issue be closed because of the comprehensive discussion in the now closed pull request #34825?

gioman commented 4 years ago

Shouldn't this issue be closed because of the comprehensive discussion in the now closed pull request #34825?

@rhurlin once the migration of db manager to the data source manager is started then this feature request would change label to "data source manager". In the meantime the feature request is valid, regardless of where it will be implemented.

rhurlin commented 4 years ago

@gioman That sound plausible, thanks for clarification.