The ST_MPointFromText() function

The ST_MPointFromText() function creates an ST_MultiPoint from a well-known text representation of type ST_MultiPoint and a spatial reference ID.

Syntax

ST_MPointFromText(WKT lvarchar, SRID integer)

Return type

ST_MultiPoint

Example

The multipoint_test table is created with the single ST_MultiPoint mpt1 column:
CREATE TABLE multipoint_test (gid  smallint,
                              mpt1 ST_MultiPoint);
The following INSERT statement inserts a multipoint into the mpt1 column using the ST_MPointFromText() function: 
INSERT INTO multipoint_test VALUES(
    1,
    ST_MPointFromText('multipoint(10.01 20.03,10.52 40.11,30.29
41.56,31.78 10.74)',1000)
);