[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