вручную добавил таблицы:
Код: Выделить всё
CREATE TABLE spatial_ref_sys (
srid INTEGER NOT NULL PRIMARY KEY,
auth_name VARCHAR(256),
auth_srid INTEGER,
srtext VARCHAR(2048),
proj4text VARCHAR(2048)
)
и
CREATE TABLE geometry_columns (
f_table_catalog VARCHAR(256) NOT NULL,
f_table_schema VARCHAR(256) NOT NULL,
f_table_nam VARCHAR(256) NOT NULL,
f_geometry_column VARCHAR(256) NOT NULL,
coord_dimension INTEGER NOT NULL,
srid INTEGER NOT NULL,
type VARCHAR(30) NOT NULL
)
когда пытаюсь выполнить запрос :
create table points ( pt geometry, name varchar );
insert into points values ( 'POINT(0 0)', 'Origin' );
insert into points values ( 'POINT(4 0)', 'X Axis' );
insert into points values ( 'POINT(0 3)', 'Y Axis' );
select name, ST_AsText(pt), ST_Distance(pt, 'POINT(4 3)') from points;
выдает ошибку:
ERROR: type "geometry" does not exist
LINE 1: create table points ( pt geometry, name varchar );insert in...