All Questions
Tagged with data-source postgresql
4 questions
0
votes
1
answer
339
views
QGIS and remote PostgreSQL/PostGIS (in cloud) slow performance
I am using QGIS 3.28.11 version and in backend I am using PostgreSQL 15.0 with PostGIS 3.3.3.
I have total 36 layers which contained in 3 groups: A, B, C. Now X user has read only access on all layers ...
3
votes
1
answer
79
views
Changing layer provider (datasource) from shapefile to PostgreSQL with PyQGIS
I have a QGIS project with several layers using shapefiles.
I want to change the datasource of each layer using a PostgreSQL table to replace the shapefile source.
I tried this code, but nothing ...
8
votes
2
answers
2k
views
How to Change Vector Datasource in QGIS 3.2.0?
QGIS 2.18 has a very good function Change Vector Datasource:
In QGIS 3.2.0 there is Update SQL layer but it doesn't work like Change Vector Datasource. When I open it, select and do update, it acts ...
1
vote
1
answer
132
views
Can a MapServer datasource be a materialized view?
I'd like to find out if there is a way that a datasource in MapServer can be a materialized view, this is due to the presence of indexes, these cannot be in views but only in materialized view - ...