After loading a polygon shapefile into PostGIS, the geometry column (geom) is blank for several features. In one case, only a single feature has the geometry calculated and all others are blank.
I'm using the PostGIS SHP and DBF loader v.2.0. I am creating a spatial index, and using COPY rather than INSERT.
I have loaded several other point datasets and they geom column is populated just fine...
(Otherwise, things are working just fine for the polygons: when I create a new feature, the geometry is calculated / geom field populated...etc.)
Have I done something wrong when importing the data?
Solution by @ThomasG77 (in comments)
PgAdmin3 [doesn't] display features that are too complex but they are present. You can try
SELECT length(ST_astext(the_geom)) from your_table to confirm or you can find "true" empty geometry with
SELECT * from your_table WHERE the_geom IS NULL;.