PostGIS
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

When I view a geometry column in PgAdmin it is blank, why?

Compared to most data types, geometries are quite large. For some versions of PgAdmin, there is a maximum amount of data that can be show in a cell, and if the record is larger than that, the cell simply appears blank.

  • You can use ST_AsText() to get a human readable form of the geometry, but that might still be too large.
  • You can use a simplifying function, like ST_Centroid() to get a geometry that is small enough to visualize.
  • You can use a summary function, like ST_NPoints() to replace the geometry with a count of the number of vertices in the geometry.
  • In more recent versions of PgAdmin, you can click the “eye” icon in the cell to get a map visualization of the geometry.

Finally, it’s possible that your column does doesn’t have any geometry in it for some reason!

SELECT Count(*) FROM mytable WHERE geom IS NOT NULL