Load Postgis layer in Qgis

Highlighted
One Star

Load Postgis layer in Qgis

Hi, I have an error using Qgis-Titan to load the layer imported with SDI.
Error message is :
"Column the_geom in "public"."boundaries" has a geometry type of GEOMETRY,
which Qgis does not currently support."
Any help appreciated.
Thanks.
Sean
One Star Fxp
One Star

Re: Load Postgis layer in Qgis

Hi Sean, this is a problem in QGis which doesn't support Type = "Geometry" in PostGis. I've the same problem using Titan, maybe it's different in latest release ?
To fix the problem, you need to define in sPostgisOutput component the geometry type (ie. Point, LineString, Polygon, Multi*...) according to your input geometries and not use the generic Geomtry type if you plan to use Qgis.
HTH. Francois
PS : type = "Geometry" is well supported by uDig.
One Star

Re: Load Postgis layer in Qgis

Hi,
QGIS does not support Geometry' Type in Titan or in lastest release, and it is not suppose to change for the next release. It could be implemented but it is not "important".
Y.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download