I seemed to have noticed that QGIS cannot detect the spatial type or SRID of a PostGIS table if the geometry column is set to anything other than "geom". You can manually tell QGIS what these fields should be but then upon opening a saved project the tables in particular seem slow to load.

Is it recommended that "geom" is used for the geometry column to speed up the table reads or could this be something un-related.

enter image description here

  • 2
    QGIS is utilizing a special table "geometry_columns". You can read more about that from PostGIS documentation. If exact geometry type is stored into geometry_columns QGIS can pick it directly. – user30184 Feb 19 at 11:48
  • Thanks @user30184 so it would appear that the type and srid fields in the "geometry_columns" table are not set. Do these need to be defined when creating the views? – AWGIS Feb 19 at 12:02
  • 2
    You need to define a column as geometry column in PostGIS. See gis.stackexchange.com/questions/154906/… for example. So far I never had issues defining multiple geometry columns of diverse names, not even when CRS and Geometrytypes are mixed. – MrXsquared Feb 19 at 15:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.