back to first page [..]
back to ["CookBook Eda"]

[[Image(source:data/Docs/trac/pourc_projette.jpg)]]

[[Image(source:data/Docs/trac/barrages_cutfrance.png,600px)]]

See the ticket #45

[[Color(,#3849ce,source)]]

[[Freemind(htdocs://site/reunion7janv.mm)]]

source:"data/Docs/trac/POSE/SWOT in Pose.mm"

!{{{ !#!html !<h2 style="color: orange">This is raw HTML</h2> !}}}

This is raw HTML

​http://trac.edgewall.org/wiki/WikiFormatting

Postgre

cd C:\Program Files\PostgreSQL\8.4\bin\ pg_restore.exe --host localhost --port 5432 --username postgres --dbname "ccm21" --verbose "C:\CelineJouanin?\riversegments.backup"

• 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);