Select empty Postgis (Postgresql) geometry column

how about

select * from district.airport  where geom is NULL;

You can try this :

select id, geom, st_isvalid(geom) from foo where st_isvalid(geom)='false' ;

You must check that your entities are valid, (if not : repaire geometry). Then the 'Iant' answer is correct :

select * from district.airport where geom is NULL;

SELECT * FROM foo WHERE ST_IsEmpty(geom);

There has to be an empty geometry like MULTIPOLYGON EMPTY, otherwise this will return nothing like in your case.

See the documentation for more details at https://postgis.net/docs/ST_IsEmpty.html

Related