Changes between Version 12 and Version 13 of Help for Celine

Timestamp:

Jul 8, 2010 3:37:04 PM (15 years ago)

Author:

celine

Comment:

--

Help for Celine

@@ -35 +35 @@
 
  * Add a primary key
+{{{
 ALTER TABLE ccm21.riversegments ADD CONSTRAINT riversegments_pkey PRIMARY KEY (gid);
+}}}
 
  * Drop a primary key
+{{{
 ALTER TABLE ccm21.riversegments DROP CONSTRAINT riversegments_pkey;
+}}}
+ * Change the srid into 3035 (ETRS1989 LAEA)
+{{{
+ALTER TABLE uga2010.uga DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE uga2010.uga SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE uga2010.uga ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+}}}