postgresql - Multipoint vs point PostGIS

Is it normal to use the geometry type 'multipoint' instead of 'point' knowing that I use it to store only one point?

How can I convert from multipoint to point?

Answer

To convert "Multipoint" to "Point", you have to use ST_Dump, for example:

SELECT (ST_Dump(the_geom)).geom AS the_POINT_geom
  FROM MULTIPOINT_table;

On the question of using "Multi" or single geometries, I use this logic:

• if every geometry has different attributes -> Single


• if a group of geometries have same attributes -> "Multi"