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

![[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>
!}}}
{{{
#!html
<h2 style="color: orange">This is raw HTML</h2>
}}}


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