--------------------------- CREATE TABLE gemeinden ( ogc_fid serial NOT NULL, land integer, regierungsbezirk integer, kreis integer, gemeinde integer, gemeindename character varying(80), gkz character varying(3), CONSTRAINT gemeinden_pk PRIMARY KEY (ogc_fid) ); SELECT AddGeometryColumn('gemeinden','wkb_geometry','25832','POLYGON',2); CREATE INDEX gemeinden_geom_idx ON gemeinden USING gist (wkb_geometry); INSERT INTO gemeinde (wkb_geometry,gemeinde) SELECT union(wkb_geometry),gemeinde from from ax_flurstuecke group by gemeinde;