[postgis-users] how to determine a geometry type?

Nicolas Ribot nicolas.ribot at gmail.com
Fri Jul 2 04:48:30 PDT 2010

> Hi Nicolas,
> Thanks for your answer, my question is really  not clear... but I would like
> to determine a geometry type by using a function, not by eyes ;)

select type
from geometry_columns
where f_table_name = 'mytable' and f_geometry_column = 'columnOfMyTable'

Type will be a string representing the geometry type


More information about the postgis-users mailing list