I have used PgAdmin III to extract the create statements.
Please find them below:
---
-- Table: my-feature
-- DROP TABLE my-feature;
CREATE TABLE my-feature
(
gid integer NOT NULL DEFAUL nextval ('"32_my-feature_gid_seq"'::regclass),
the_geom geometry,
...
CONSTRAINT "32_my-feature_pkey" PRIMARY KEY (gid ),
CONSTRAINT "32_my-feature_the_geom_check" CHECK (geometrytype(the_geom) =
'LINESTRING'::text OR geometrytype(the_geom) = 'MULTILINESTRING'::text OR
the_geom IS NULL),
CONSTRAINT "32_my-feature_the_geom_check1" CHECK (st_srid(the_geom) = 32632),
CONSTRAINT "32_my-feature_the_geom_check2" CHECK (st_ndims(the_geom) = 2)
)
WITH (
OIDS=FALSE
);
ALTER TABLE my-feature
OWNER TO postgres;
-- Index: "32_my-feature_the_geom_gist"
-- DROP INDEX "32_my-feature_the_geom_gist";
CREATE INDEX "32_my-feature_the_geom_gist"
ON my-feature
USING btree
(the_geom );
Thanks again,
Sondre
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
