Hey Robert,

I'm not sure if your question is still unanswered but you might have a look at the table "geometry_columns". There should be an entry for your spatially enabled table if the geometry was registered correctly.

Otherwise the function ST_GeometryType(your_geometry_field) should give the needed information.

Bye,
Marc


Robert Hicks schrieb:
Hello all, is there a way to determine the geometry of a table in Postgres 8.2/Postgis? I want to execute a sql query against a table and get back POLYGON, LINE, etc. and I am guessing there is a stored procedure for this.

Thanks!
------------------------------------------------------------------------

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to