[postgis-users] Determining geometry type from table

[Marc Jansen]

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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>