Questions tagged [database-manager]
The database-manager tag has no summary.
6 questions
2
votes
2
answers
171
views
QGIS & PostGIS STRING_AGG in virtual layer definition returns "no such function: STRING_AGG"
i've defined the following SQL statement in the query editor of qgis' db manager:
select sd.fk_polyg, count(sd.fk_polyg), STRING_AGG(DISTINCT sl.typ, ', ') as concat_typ
from schaden_stein_detail as ...
- 978
1
vote
0
answers
62
views
QGIS Database Manager export removes properties (which is unwanted)
I'm working with a QGIS server and when exporting a layer to a GeoJSON file, I 'm getting:
The wrong CRS
None of my properties
{
"type": "FeatureCollection",
"name": &...
1
vote
1
answer
338
views
Importing Shapefile to PostGIS using QGIS DB Manager
I am trying to import a shapefile from my QGIS project to my PostGIS schema using DB manager.
I want to create a new table in my public schema and I have an ERROR: relation "spatial_ref_sys" does ...
- 21
4
votes
0
answers
2k
views
"Geom-type or SRID not allowed" errors when importing sqlite layer to DB manager in QGIS?
I am trying to import an sqlite file to the QGIS DB Manager with default import settings. While the layer displays fine in the graphical interface, the DB Manager only partially loads it, stopping ...
- 257
2
votes
2
answers
2k
views
QGIS DB Manager - load as new layer not loading
After successfully running an SQL query on two tables and some results in 3 columns, I would really like to be able to display it in the canvas. Apparently, that function is not doing anything, not ...
- 773
1
vote
1
answer
2k
views
What does "PostgreSQL layer has no primary key." when loading layer from database manager mean?
I have a complex join that I have working in the database manager but when I try and load it nothing appears and I found this in the logs:
PostgreSQL layer has no primary key.
What is actually ...
- 3,042