[postgis-users] Shapes to PG

Nicolas Ribot nicky666 at gmail.com
Mon Jan 26 10:33:22 PST 2009


> ?? What kind of "admin" is that? What chance of checking, whether the_geom
> is valid or not, do I have?
>

Well, pgAdmin is intended to administrate PostgreSQL, not postGIS and
its geometries.
To check your geometries for nullity or validity, SQL seems to be your friend:

select count(*) from my_table where the_geom is null;
select distinct st_isvalid(the_geom) from my_table; -- for OGC validity
etc.

HTH
Nicolas



More information about the postgis-users mailing list