Re: [QGIS-Developer] postgis connection to server instead of individual databases?

2018-01-27 Thread Jorge Gustavo Rocha
Hi, Technically, we always need to connect to a database :-) What we can do is to connect to the 'postgres' database using the user credentials to query all the available databases, and then use something like "DECLARE alldbs CURSOR FOR select * from pg_database" to retrieve the list of available

Re: [QGIS-Developer] postgis connection to server instead of individual databases?

2018-01-27 Thread Paolo Cavallini
Il 27/01/2018 12:36, Andreas Neumann ha scritto: > Just a wish: if we go this route, please, please, don't open all DBs at > once. Just list the available DBs, let the user choose one of the > available ones and then open only the DB the user is interested in. > Otherwise it would be a performance

Re: [QGIS-Developer] postgis connection to server instead of individual databases?

2018-01-27 Thread Andreas Neumann
Hi, I agree that it would be desirable that all available DBs would be listed. As to services: the pg_service.conf file also contains several entries, so it would also be possible to list all available service configurations. Just a wish: if we go this route, please, please, don't open all D

Re: [QGIS-Developer] postgis connection to server instead of individual databases?

2018-01-27 Thread Paolo Cavallini
Il 27/01/2018 10:05, Raymond Nijssen ha scritto: > It would be very handy if QGIS could remember, for example, my > localhost-postgres:postgres connection and update the available > databases for me. > > Would that be possible? (Or is it but am I doing something wrong here?) agreed, I always won

[QGIS-Developer] postgis connection to server instead of individual databases?

2018-01-27 Thread Raymond Nijssen
Dear developers, Today I suddenly wondered: Why can pgAdmin have a connection to a database *server* and automatically list all databases that are present while in QGIS I need to create a new connection for every individual postgresql/postgis database? It would be very handy if QGIS could re