Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I tried to import in QGIS a layer from a PostgreSQL table with a geography type column created through the extension PostGIS.

I noticed that QGIS doesn't seem to like the geography column...

Here the step to create the column...

ALTER TABLE traffico ADD COLUMN geog geography(POINT,4326);

then to update the column...

UPDATE traffico SET geog = ST_GeogFromText('SRID=4326;POINT(' || lon || ' ' || lat || ')');

but then when I connect QGIS to my server I see this:

Import PostGIS layer to QGIS

There's no way I can find to tell QGIS to treat my column as a geography type instead of geometry type. Indeed if I try to upload the layer like this the point coordinates do not correspond to reality.

share|improve this question
Please go though following links which contains (difference between Geography and the geometry data type ,when to use this type)… ,… – Sunil Feb 5 '13 at 5:43
Based on the comments to this question, it seems like it's possible if you use the template to create your PostGIS database… – raphael Dec 2 '15 at 17:18

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.