My primary PostGIS database has 12 schemas (schemae? TNIRN...), some of which have nasty-sized tables. The DB is on localhost, on my own machine.
For the most part, the actual working tables are in one schema ('aa') - and are at least 1, and often 2 or 3, order[s] of magnitude smaller than the nasty-sized tables.
Every time I want to add a PostGIS layer, the
Layer->Add Layer->Add PostGIS layers tool makes me wait while (10 minutes) it adds every.single.schema and every.single.geometry-column to the selection universe, when I really want it to stop when it's finished loading schema 'aa'.
Top marks to QGIS for finding all the geometries in a pretty massive database, but in the ordinary course of events I am only interested in 'aa'.
The name 'aa' is chosen specifically because it does not overlap in any way with names of the 'big-ugly' shemas (schemae? TNIRN). When I use 'Search Options' and tell it 'Search in columns'=Schema for the search term 'aa', it still loads every table.
Is it possible to restrict the domain of 'Add PostGIS Layers' to only look at one schema? I've R'd TFD to no avail.
inb4 "have a different database for your working schema". Not possible, since there is beaucoup interaction between 'aa' and other schemas (schemae? TNIRN) when actual SQL-ish work is to be done.
Versions: PostgreSQL 9.3.5, PostGIS 2.1.3, QGIS 2.6.1-Brighton.