DROP TABLE IF EXISTS peter.kml_points;
CREATE TABLE peter.kml_points
(
  id serial NOT NULL,
  "name" varchar(20)
);

SELECT AddGeometryColumn('peter', 'kml_points', 'the_geom', 25832, 'POINT', 2);

INSERT INTO peter.kml_points (name, the_geom) VALUES ('R3 GIS', ST_GeomFromText('POINT(666745 5166706)', 25832));
INSERT INTO peter.kml_points (name, the_geom) VALUES ('Kurhaus', ST_GeomFromText('POINT(665445 5170811)', 25832));
