Форумы GIS-Lab.info

Код: Выделить всё

  CREATE OR REPLACE FUNCTION  insert_into_wgs()
RETURNS void AS
$$
BEGIN
	INSERT INTO filedata (id,mydata,the_geom)  
	SELECT id,mydata,ST_TRANSFORM(the_geom,4326)
	FROM filedata_temp
	WHERE id NOT IN (SELECT id FROM filedata);
end;
$$
  LANGUAGE 'plpgsql'

Код: Выделить всё

	try{
	Connection ce_proc= null;
  ce_proc = DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgis","postgres","123456");
  CallableStatement proc = (CallableStatement) ce_proc.prepareCall("{call insert_into_wgs()}");
  proc.execute();
  proc.close();
  ce_proc.close();
	}
	catch (SQLException e) {}