The ST_GeometryType method returns a string containing the specific type name of geometry-expression.
The value IS OF( type ) syntax can also be used to determined the specific type of a value.
Note
By default, ST_GeometryType uses the original format for a geometry, if it is available. Otherwise, the internal format is
used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.