Thanks, Bernard and Andreas. Yes, I did exactly as your kind recommendations shortly after sending out my initial email inquiry and realized such workaround would work equally as well.
In essence, I created a new PostgreSQL database called "search_wsgi", extended the DB for PostGIS and DBLink, and then created new "search" tables in this new DB based on other PostGIS databases and simply established a DB_CONN_STRING "connection" to the new "search_wsgi" database. Once I "reloaded" or "restarted" the Apache server, I am now able to search for geometries on my Qgis web client based on the various search tables I generated in the "search_wsgi" DB. Note, I have always used DBLink and never FDW so I will have to try FDW's in the future when requiring data outside my connected PostgreSQL DB. Cheers, -Tony Sent from my iPhone > On Nov 26, 2015, at 4:58 AM, Andreas Neumann <[email protected]> wrote: > > Or use foreign data wrappers (fdw) - which is I believe - the more modern > version of dblink. > > You can register a table from another database and it will act as it would be > local. > > Andreas > >> On 26.11.2015 09:21, Bernhard Ströbl wrote: >> Hi, >> >> workaround: use dblink to mirror the relations from the other dbs into the >> "main" db >> >> Bernhard >> >>> Am 25.11.2015 um 22:03 schrieb Tony Pham: >>> Hi all, >>> >>> For the WSGI Search capabilities on QGIS Web Client, is it possible to >>> establish search capabilities using multiple databases (i.e., tables >>> within multiple databases)? >>> >>> I have QGIS projects which utilize different PostGIS databases and would >>> like to be able to list all the various databases in my qwc_connect.py >>> Python file but realize that the DB_CONN_STRING only allows for the >>> connection to a single database. >>> >>> Has anyone employed or developed a workaround for this? >>> >>> Regards, >>> -Tony >>> >>> >>> __________ Information from ESET Mail Security, version of virus >>> signature database 12624 (20151125) __________ >>> >>> The message was checked by ESET Mail Security. >>> http://www.eset.com >>> >>> >>> _______________________________________________ >>> Qgis-developer mailing list >>> [email protected] >>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer >>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer >> >> >> >> __________ Information from ESET Mail Security, version of virus signature >> database 12626 (20151126) __________ >> >> The message was checked by ESET Mail Security. >> http://www.eset.com >> >> >> _______________________________________________ >> Qgis-developer mailing list >> [email protected] >> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer >> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer > > _______________________________________________ > Qgis-developer mailing list > [email protected] > List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer _______________________________________________ Qgis-developer mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
