Change order of PostGIS Layer in Layer select box

[horst.duester@…]

In qgis/src/gui/qgsdbsourceselect.cpp change line 520 from

sql += " order by f_table_name";

to

sql += " order by f_table_schema,f_table_name";

As the result prior the schemanames will be ordered and than the tablenames. It is much more easier to find a layer.

[gsherman]

Fixed in r5184

[mwtoews]

My projects use multiple geometry columns for each table, and I've noticed the geometry column having different sortings.

So naturally, please update qgis/src/app/qgsdbsourceselect.cpp:

558c558
<                 "order by f_table_schema,f_table_name";
---
>                 "order by f_table_schema,f_table_name,f_geometry_column";

[pcav]

Can the patch be applied?

[jef]

applied in r10672