search

3liz / qgis-pgmetadata-plugin

QGIS Plugin to manage some metadata from PostgreSQL layer
GNU General Public License v2.0
12 stars 10 forks source link

Locator results: inverted order of schema and table in displayString #128

Closed effjot closed 2 years ago

effjot commented 2 years ago

In fetch_result_single_database(), the displayString for the locator results is created with the unusal order table first, schema second:

    sql = "SELECT concat(d.title, ' (', d.table_name, '.', d.schema_name, ')') AS displayString,"

I’d suggest to use the common schema.table order. Thanks!