使用PostgreSql心得

下载安装就不说了，直接打开建表

> CREATE TABLE mylocation (   
  id SERIAL PRIMARY KEY,  
  geom GEOMETRY(Point, 4326),  
  name VARCHAR(128),  
  x double precision,  
  y double precision  
);   

第一次建表报错，type “geometry” does not exist
查了很多之后，需要执行一句话

CREATE EXTENSION postgis;
In detail,
open pgAdmin select (click) your database click “SQL” icon on the bar
run “CREATE EXTENSION postgis;”

简单来说就是执行以下CREATE EXTENSION postgis;然后重启一下就好了，之后插入数据

insert into mylocation (geom,name,x,y) values (ST_GeomFromText('POINT(116.34462436642 39.853139258537)',4326),'yxy',116.34462436642,39.853139258537)；

插入了好几条类似这样的数据，查询排序

SELECT id, name,geom,x,y,   ST_DistanceSphere(  
                      geom,  
                      ST_GeometryFromText('POINT(116.47894796832 39.909841393006)')) distance  
FROM mylocation  ORDER BY distance asc;

接下来研究重点是如何用Java操作这个数据库，有知道的求帮助~~~