When i imported a shapefile which contains some polygons into PostGIS by command line on Win 7, a problem puzzled me: The sql file generated by shp2pgsql opened with notePad has the geom (Mutipolygon) value ,however when put this sql file in pgAdminIII, the value was empty..why??some one can help me??

  • 1
    please give examples of the sql – Mapperz Mar 8 '13 at 15:20
  • I had issues with that before too, and if I remember correctly some coordinate system wouldn't show data in pgAdmin and I have to change it. – Michalis Avraam Mar 8 '13 at 17:31

PgAdmin has limits on the largest object it can display in a table cells. Large geometries frequently exceed this limit, which results in an "empty" cell, confusing to new users. If you call ST_NPoint(geom) or ST_GeometryType(geom) you can see that the geometry is in fact there, and does have data in it, you just cannot see it in a PgAdmin cell.

| improve this answer | |

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.