Postgis安装:输入“geometry”不存在 [英] Postgis installation: type "geometry" does not exist
本文介绍了Postgis安装:输入“geometry”不存在的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
错误:类型geometry不存在
有谁知道我该如何解决它?
解决方案
我遇到了同样的问题,但是通过运行以下代码修复了这个问题:
CREATE EXTENSION postgis;
详细地说,
- 打开pgAdmin
- 选择(单击)您的数据库
- 单击栏上的SQL图标
- 运行CREATE EXTENSION postgis;代码
- open pgAdmin
- select (click) your database
- click "SQL" icon on the bar
- run "CREATE EXTENSION postgis;" code
I am trying to create table with Postgis. I do it by this page. But when I import postgis.sql file, I get a lot of errors:
ERROR: type "geometry" does not exist
Does anybody know how can I fix it?
解决方案
I had the same problem, but it was fixed by running following code
CREATE EXTENSION postgis;
In detail,
这篇关于Postgis安装:输入“geometry”不存在的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文