Changes between Version 3 and Version 4 of Download and load RHT

Timestamp:

May 17, 2011 2:43:21 PM (14 years ago)

Author:

celine

Comment:

--

Download and load RHT

@@ -93 +93 @@
 set client_encoding to 'latin1';
 copy rht.attributs_rht_fev_2011  from 'D:/CelineJouanin/RHT_Estimkart/Attributs_RHT_fev_2011_UTF8.csv' with csv delimiter as ';' header; 
+ERREUR:  la valeur d'une clé dupliquée rompt la contrainte unique « pk_id_drain »
+CONTEXT:  COPY attributs_rht_fev_2011, ligne 104442 : « 223988;2.30;19.20;1;"Loir";"115.00";"238.70";14.30;229;5;;2231.00;;;"1.0e-03";;;0.00;;;1.00000004749... »
 
-copy 
-alter table rht.rht add constraint  pk_id_drain primary key (ID_DRAIN);
-alter table rht.attributs_rht_fev_2011 add constraint  pk_id_drain primary key (ID_DRAIN);
-set client_encoding to 'latin1';
-copy rht.attributs_rht_fev_2011  from 'D:/CelineJouanin/POSEProject/Ireland/DataIreland/Station_14_Eel_Db_MI_Rivers.csv' with csv delimiter as ';' header; 
+********** Erreur **********
 
-ALTER TABLE "Attributs_RHT_fev_2011" SET SCHEMA rht
-ALTER TABLE rht."Attributs_RHT_fev_2011" RENAME TO Attributs_RHT_fev_2011
+
+
 }}}