Changes between Version 64 and Version 65 of PATE Anguille

Timestamp:

Mar 7, 2012 5:34:25 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -501 +501 @@
 }}}
 
+'''Table "tab complété pour Qe et mort.xls" mail Peggy 1/03/2012'''
+{{{
+DROP TABLE IF EXISTS rht.pate_mortalite;
+create table rht.pate_mortalite
+(
+  num double precision,
+  bv character varying(80),
+  nomcart character varying(80),
+  nomtopo character varying(80),
+  commnom character varying(80),
+  id_roe character varying(80),
+  nom character varying(80),
+  ouvrage character varying(80),
+  dmer character varying(80),
+  H character varying(80),
+  q_equipement_renseigne character varying(80),
+  module character varying(80),
+  qe_qm character varying(80),
+  selection numeric,
+  extrapolation character varying(80),
+  q_equipement numeric,
+  mortalite50cm numeric,
+  mortalite70cm numeric,
+  mortalite90cm numeric
+);
+
+set client_encoding to 'latin1';
+copy rht.pate_mortalite from 'D:/CelineJouanin/PATE/pate_mortalite.csv' with csv header delimiter as ';' NULL AS 'NA'; -- lines
+
+}}}
 
 == Export table ==