Insert Point (Geometry) value in PostgreSQL with JDBC

Question

Please give me code example to insert records containing SQL statement:

insert into TABLE 
(id, value1, value2, point, value3) 
values
(1,'A', 'M', POINT (13.45646, 56.61782),5);

in JDBC/Postgresql code.

If anyone has solution of PreparedStatement or anyother useful solution it is highly welcomed!

Mike T · Accepted Answer · 2018-07-31T23:09:19.087

At the simplest level, you can build a prepared statement using geometry constructors to pass parameters.

insert into "TABLE"(id, value1, value2, point, value3)
values(1, $1, $2, ST_SetSRID(ST_MakePoint($3, $4), 4326)), $5);

Where $3 and $4 are the longitude and latitude.

See also the PostGIS documentation for the JDBC interface which may be useful with other geometry types (LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon).

1 Answers1