road.sql

来自「Java的框架」· SQL 代码 · 共 16 行

CREATE TABLE prrm_road
(
  gid serial NOT NULL,
  id int4,
  road_name varchar,
  road_type varchar,
  the_geom geometry,
  CONSTRAINT prrm_road_pkey PRIMARY KEY (gid),
  CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL),
  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = -1)
) 
WITHOUT OIDS;
ALTER TABLE prrm_road OWNER TO postgres;

INSERT INTO "geometry_columns" VALUES ('','public','prrm_road','the_geom',2,4326,'MULTILINESTRING');