From d7e3011a44a85f32aaab975f603f17a9bec198c5 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期日, 20 十一月 2022 14:54:36 +0800
Subject: [PATCH] 1
---
data/db_tab.sql | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index 64a20b4..5393048 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -970,10 +970,17 @@
create_user integer,
create_time timestamp(6) without time zone default now(),
update_user integer,
- update_time timestamp(6) without time zone
+ update_time timestamp(6) without time zone,
+ geom geometry(Point, 4490)
);
+create index if not exists md_zxcg_geom_idx on md.md_zxcg using gist (geom);
+drop index if exists md_zxcg_geom_idx cascade;
comment on table md.md_zxcg is '涓嚎鎴愭灉琛�';
+vacuum analyze md.md_zxcg;
+insert into md.md_zxcg (zh, geom) values ('A01', ST_GeomFromText('POINT(95.80461853400004 34.13862467200005)'));
+insert into md.md_zxcg (zh, geom) values ('A02', ST_GeomFromText('POINT(119.873000 39.392000)'));
+select gid,zh,ST_ASText(geom) from md.md_zxcg;
select * from md.md_zxcg;
-- drop table if exists md.md_gdcg;
--
Gitblit v1.9.3