Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [dbmanager]

The tag has no usage guidance.

0
votes
2answers
127 views

QGIS 3 - Creating a new layer through DB Manager

When I load a polygon shp file into QGIS 3.6 and run a query finding the centroids of the polygons, I cannot load it back to the layers panel. The same operation works fine in QGIS 2.18.2. The query ...
2
votes
0answers
85 views

In QGIS, How to add the database connection in DB Manager via Python [closed]

I am using QGIS 3.0.2 I want to add connection settings in DB Manager via Python script. is it possible ? (I am interested in PostGIS and Oracle Spatial for now) This script will save the ...
1
vote
1answer
32 views

Run query between PostGIS layer and Shapefile layer with DB Manager

Is it possible to use the DB Manager in QGIS (I am using version 3.4) to run a SQL query between a project layer (e.g. shapefile) and a PostGIS layer? For example, I have a polygon shapefile in my ...
1
vote
0answers
41 views

How to attach one spatialite database to another in db manager

I'm trying to attach one database to another so that data from it can be used in queries. I'm using ATTACH DATABASE '{full url}' AS {database_name}; No errors actually occur, but when I run PRAGMA ...
1
vote
2answers
135 views

Save query result from QGIS to csv

I have a layer saved to spatialite which I want to query and save part of to csv. Even the query result takes a very long time to load to the browser (2.5M rows) even if I load it without geometry. ...
3
votes
1answer
220 views

Import Shapefile to PostGIS in QGIS' DB Manager without using its ID column

I have a shapefile with a "id" field in which some non-unique ID numbers exist (don't ask). When I try to import this to a PostGIS database using QGIS' DB Manager, it tries to re-use those IDs are ...
0
votes
1answer
49 views

PostGIS layer visible in QGIS Browser panel but displayed as not connected in DBManager

I have added my database as a workshop and you can see the layers in public schema. but whereas in Db manager it is saying NOT CONNECTED. how can I resolve this? this is running on localhost. on ...
0
votes
1answer
96 views

Unable to connect to connect to Postgres server using DB Manager: unable to convert a QVariant of type 10 to a QMetaType of type 2

Using QGIS 3.0.3 and QGIS 3.1 nightly, I can't connect to a postgres Database using the DB Manager and get the following error: TypeError: unable to convert a QVariant of type 10 to a QMetaType of ...
8
votes
1answer
146 views

Is there a history/log file for QGIS DB Manager?

When using PostGIS through psql I can look back through the commands I've run in ~/.psql_history. Is there any equivalent log/history file for when I'm connected through QGIS DB Manager? I've ...
3
votes
2answers
311 views

Saving queries in QGIS DB Manager

Recently I started using DB Manager to query Spatialite DB. I was happy to see that QGIS DB Manager had a "save query" option, but it seems it saves them only for the current session of QGIS. When I ...
2
votes
0answers
318 views

Oracle connections fail in QGIS 3.0 DB Manager

Oracle connections are working OK in the Browser panel, the Data Source Manager, and the Python console, but any attempt to open a connection in the DB Manager is failing. The database is a fresh 12.1....
6
votes
3answers
121 views

How to disable addition of database name to layer name when adding a vector layer in QGIS?

I am using QGIS version 2.18.14. When I add a vector layer from a file geodatabase, I choose the OpenFileGdb driver and then pick the layers I would like to have on the map. However, the layers are ...
2
votes
1answer
186 views

Spatialite Spatial Views doesn't display in QGIS

I have views stored in a spatialite database accessed via QGIS. The views were created by another person on a different computer. The geometry column is well registered in the table ...
1
vote
1answer
103 views

SQL query : finding a word in a shapefile

I have a punctual shapefile containing the name of geographic locations (attribute 'name') Using DB Manager of Qgis, I would like create an SQL query to find, within the shape, the name of a location ...
3
votes
1answer
186 views

Saving view to different schema using QGIS DB manager?

When I ask to save a query to a view QGIS pops up a dialogue box asking the for a name and then saves the view in the public schema with that name. I have tried "layers.name" but this just puts "...
3
votes
1answer
205 views

How to preserve geometry when saving vector files to a SpatiaLite db (QGIS)

I have been trying to add multiple vector layers to a SpatiaLite database, however using the integrated DB Manager in QGIS 2.14.10 and 2.18.7, whenever I add a shapefile using the "Import Layer/File" ...