postgresql存图片字段类型_Postgresql存储Geometry对象类型

查询Geometry

select ST_GeomFromText('Polygon((117.357442 30.231278,119.235188 30.231278,119.235188 32.614617,117.357442 32.614617,117.357442 30.231278))');

设计Geometry字段表

政区表：Geometry=Polygon

drop table if EXISTS aggregate_state;

/***创建政区表***/

create table aggregate_state(

pk_uid serial primary key,

code CHARACTER VARYING(20) NOT NULL,

"name" CHARACTER VARYING(100) NOT NULL,

zoom INTEGER NOT NULL,

geom geometry(Polygon,4326) NOT NULL ,/*geom public.geometry(Polygon,4490),*/

longitude double precision ,

latitude double precision

);

空间业务表：Geometry=Point

drop table if EXISTS aggregate_spatial;

/***创建空间业务表***/

create table aggregate_spatial(

pk_uid serial primary key,

sheng CHARACTER VARYING(20),

shi CHARACTER VARYING(20),

xia