Changes between Version 44 and Version 45 of Help for Celine
- Timestamp:
- Jan 5, 2012 10:03:48 AM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Help for Celine
v44 v45 44 44 SRID ["srid"] 45 45 {{{ 46 #!sql 46 47 select * from spatial_ref_sys where srtext LIKE '%NTF%'; 47 48 }}} … … 51 52 52 53 {{{ 54 #!sql 53 55 --- Nombre de colonnes dans une table 54 56 select relnatts from pg_class where relname='stationsp2' … … 83 85 * Intégration d'une colonne géométrique 84 86 {{{ 87 #!sql 85 88 SELECT AddGeometryColumn ( 'rht','attributs_rht_fev_2011_vs2','the_geom',3035,'MULTILINESTRING',2); 86 89 update rht.attributs_rht_fev_2011_vs2 set the_geom=rht.the_geom from rht.rht … … 90 93 * Add a primary key 91 94 {{{ 95 #!sql 92 96 ALTER TABLE ccm21.riversegments ADD CONSTRAINT riversegments_pkey PRIMARY KEY (gid); 93 97 }}} … … 95 99 * Drop a primary key 96 100 {{{ 101 #!sql 97 102 ALTER TABLE ccm21.riversegments DROP CONSTRAINT riversegments_pkey; 98 103 }}} 99 104 * Change the srid into 3035 (ETRS1989 LAEA) 100 105 {{{ 106 #!sql 101 107 ALTER TABLE uga2010.uga DROP CONSTRAINT enforce_srid_the_geom; 102 108 UPDATE uga2010.uga SET the_geom = ST_transform(the_geom, 3035); … … 106 112 * Create view of a query 107 113 {{{ 114 #!sql 108 115 CREATE VIEW results AS select * from ccm21.riversegments r inner join ccm21.resultmodel re on re.res_wso1_id=r.wso1_id 109 116 }}} … … 113 120 114 121 {{{ 122 #!sql 115 123 DROP INDEX IF EXISTS ccm21.indexriversegments_wso1_id; 116 124 CREATE INDEX indexriversegments_wso1_id … … 157 165 Permet connaitre id_drain qui n'a pas d'attribut 158 166 {{{ 167 #!sql 159 168 select * from rht.rht where id_drain not in (select id_drain from rht.rht right outer join rht.attributs_rht_fev_2011 on id_drain=id_drainattr) 160 169 }}}
