Sort schema list in SPIT plugin. Patch provided by Horst Duester

qgis · Feb 22, 2012 · b67a6f1 · b67a6f1
1 parent 083e4c7
commit b67a6f1
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/src/plugins/spit/qgsspit.cpp b/src/plugins/spit/qgsspit.cpp
@@ -476,7 +476,7 @@ void QgsSpit::dbConnect()
       }
     }
 
-    QString schemaSql = "select nspname from pg_namespace where has_schema_privilege(nspname, 'CREATE')";
+    QString schemaSql = "select nspname from pg_namespace where has_schema_privilege(nspname, 'CREATE') order by nspname";
     PGresult *schemas = PQexec( conn, schemaSql.toUtf8() );
     // get the schema names
     if ( PQresultStatus( schemas ) == PGRES_TUPLES_OK )