PostgreSQL创建空间数据库

古城微笑少年丶 2022-11-21 09:29 260阅读 0赞

# 创建数据库 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70_pic_center]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70_pic_center 1]

# 添加postgis扩展，使之成为支持空间类型的空间数据库 #

create extension postgis

# 字段设置为geometry类型 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70_pic_center 2]

# 插入空间数据 #

insert into test(id,shape) values(1,point(12.32232442,43.2324535)::geometry);

![在这里插入图片描述][20201031000041333.png_pic_center]

# 查询空间数据 #

select st_astext(shape) from test;

![在这里插入图片描述][20201031000208856.png_pic_center]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70_pic_center]: /images/20221120/41e7529add6349909045074ca655a933.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221120/5f59060bf7f24492a8f60c4ed8251402.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221120/75d1c9baa8714afd9118cdd8dfe0a12a.png
[20201031000041333.png_pic_center]: /images/20221120/fcf9f91b32ee4c9caf488c26752b34e7.png
[20201031000208856.png_pic_center]: /images/20221120/b58e7586a41045b9a81ee6f32b96165a.png