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

[Nicolas Ribot]

> 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

Nicolas