Create one PostGIS connection in QGIS with multiple databases from one host?

Question

I have a number of spatial databases each containing multiple schemas on one server, I want to use QGIS to examine layers,

Is it possible to create one PostGIS connection in QGIS and add all databases at once?

All of them share the same host and it is a really long list of databases.

Answer 1

No, this is not possible.

Each connection in QGIS is configured for one specific database.

If possible you can restructure your database to use schemas instead of databases. Or you can try to reduce the amount of manual work by using the python api to create the connections or by editing the ini file in the profile.

Answer 2

It is not possible to do it with one connection.

Below steps can help you to quickly add more connections.

1. Create first PostGIS connection. I recommend you to save username and password in Qgis password manager, in this case only authentication ID is visible. See this tutorial for more info.
2. Save connection to xml: right click on PostGIS in Browser -> save Connections -> select connection that you want to export and save to xml:

3. Open XML file with text editor, copy/paste connection details from connection created in step 1 and change name and database for each new connection that you need. Save and close XML.
4. Import edited XML: Right click on PostGIS -> Load Connections -> Select XML file -> Select all connections that you want to import (exclude one that you already have from step 1).