postgresql – 将POINT插入postgres数据库

我正在使用node-postgres

使用POSTGRES管理面板生成的脚本将更新查询显示为

UPDATE public.places SET id =？,user_id =？,business_name = ?,alternate_name = ?,primary_category = ?,categories = ?,description = ?,address = ?,city = ?,state = ?,country =？,zip = ?,指向WHERE< condition&gt ;; 我如何从纬度和经度中获得点数？ 我已经看过几个使用POSTGIS的答案,但无法使其正常工作. 在POSTGRES(https://www.postgresql.org/docs/9.2/static/xfunc-sql.html)的文档中提到我们可以使用点'(2,1)’,但这不适用于pg查询.

我现在拥有的：

var config = {
  user: 'postgres',database: 'PGDATABASE',password: 'PGPASSWORD!',host: 'localhost',port: 5432,max: 10,idleTimeoutMillis: 30000
};

更新部分：

app.post('/updatePlaces',function(req,res,next) {
    console.log("Update");
    console.log(req.body.places);
    pool.query('UPDATE places SET address = $1,alternate_name = $2,business_name = $3,categories = $4,city = $5,country = $6,description = $7,point = $8,primary_category = $9,state = $10,zip = $11',[req.body.places.address,req.body.places.alternate_name,req.body.places.business_name,req.body.places.categories,req.body.places.city,req.body.places.country,req.body.places.description,(req.body.places.point.x,req.body.places.point.y),req.body.places.primary_category,req.body.places.state,req.body.places.zip],function(err,result) {
      if(err) {
          console.log(err);
          return err;
      }

      res.send(result.rows[0]);
    });
});

尝试了许多不同的传递方式：

>(req.body.places.point.x,req.body.places.point.y)
> point(req.body.places.point.x,req.body.places.point.y)
>点'(2,1)’

所有上述抛出错误.我需要使用POSTGIS吗？