I have an instance of DB Manager running and I have TWO connections present in the left pane of the DB manager form.

  1. First connection is to a static shapefile on my local file system
  2. Second connection is to a PostgreSQL DB-table

I would like to run a compound query between the two in DB Manager.

However, The problem is when you instantiate an SQL window it is either associated with one or another connection. Any suggestions.

Is there a way to perform such a query with in QGIS Manager.

I am running QGIS v2.18.11 and we do not have any shp plugins, availabl e and nor the means to download them

  • Have you tried using virtual layers? Using virtual layers you can relate different data sources using SQL. To create the virtual layers the supported query language is SQLite and SpatiaLite. – Leo Cardona Aug 14 '20 at 15:22
  • I have had limited exposure to QGIS but I will look into how to create virtual layers for both connections – user9491577 Aug 14 '20 at 15:26
  • Maybe this video can help you youtube.com/watch?v=coTSHnWvZXA – Leo Cardona Aug 14 '20 at 15:31
  • Virtual layers do not exist in QGIS v2.18.11 – user9491577 Aug 14 '20 at 22:51
  • Virtual layer exists in version 2.18.11 even from version 2.14 it could be used already. qgis.org/en/site/forusers/visualchangelog214/… – Leo Cardona Aug 14 '20 at 23:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.