pg数据库提示parse error at position 2 within geometry解决方法:
之前写的sql语句如下,但是一直报错:
UPDATE substation2 set geom=st_geomfromtext(concat(E'\'','POINT(',jd,' ',wd,')',E'\''),'4326')
经过修改成:
UPDATE substation2 set geom=st_geomfromtext('POINT('|| jd ||' '|| wd ||')','4326')
成功!