Форумы GIS-Lab.info

Код: Выделить всё

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...

Код: Выделить всё

SELECT AddGeometryColumn('','table','the_geom',4326,'POINT',2);