Opened 15 years ago

Closed 15 years ago

Last modified 7 years ago

#20 closed task (fixed)

Intégration du codier csp

Reported by: cedric Owned by: celine
Priority: major Milestone:
Component: SIG-data Version: EDA2.0
Keywords: POSTGRES Cc:

Description (last modified by cedric)


Attachments (1)

BDMAP_CODIER.csv​ (174.5 KB) - added by cedric 15 years ago.
CSP.codier au format utf8

Download all attachments as: .zip

Change History (13)

comment:1 Changed 15 years ago by cedric

  • Status changed from new to accepted

comment:2 Changed 15 years ago by cedric

creation de la base

comment:3 Changed 15 years ago by cedric

  • Description modified (diff)

comment:4 Changed 15 years ago by cedric

  • Description modified (diff)

script sql

create schema csp;
drop  table if exists csp.codier
create table csp.codier ("cd_id" integer,
			"cd_fc_id" integer,
			"cd_code" varchar(10),
			"cd_libc" varchar(10),
			"cd_libl" varchar(10),
			"cd_chaine1" integer,
			"cd_chaine2" varchar(10),
			"cd_num1" integer,
			"cd_num2" integer,
			"cd_date1" timestamp,
			"cd_date2" timestamp,
			"cd_dt_cre"timestamp,
			"cd_dt_maj" timestamp,
			"cd_qi_maj" varchar(20),
			CONSTRAINT c_pk_cd_id PRIMARY KEY (cd_id)
			);

Changed 15 years ago by cedric

CSP.codier au format utf8

comment:5 Changed 15 years ago by cedric

create schema csp;
drop table if exists csp.codier;
create table csp.codier ("cd_id" integer,

"cd_fc_id" integer,
"cd_code" varchar(30),
"cd_libc" varchar(30),
"cd_libl" text,
"cd_chaine1" varchar(60),
"cd_chaine2" varchar(30),
"cd_num1" integer,
"cd_num2" integer,
"cd_date1" timestamp,
"cd_date2" timestamp,
"cd_dt_cre"timestamp,
"cd_dt_maj" timestamp,
"cd_qi_maj" varchar(20),
CONSTRAINT c_pk_cd_id PRIMARY KEY (cd_id)
);

copy csp.codier from 'c:/base/BDMAP_CODIER.csv'
WITH DELIMITER ';'

CSV HEADER ;

comment:6 Changed 15 years ago by cedric

  • Owner changed from cedric to celine
  • Status changed from accepted to assigned

comment:7 Changed 15 years ago by celine

  • Status changed from assigned to accepted

comment:8 Changed 15 years ago by cedric

  • Resolution set to fixed
  • Status changed from accepted to closed

comment:9 Changed 15 years ago by cedric

  • Resolution fixed deleted
  • Status changed from closed to reopened

comment:10 Changed 15 years ago by cedric

  • Keywords POSTGRES added

comment:11 Changed 15 years ago by cedric

  • Resolution set to fixed
  • Status changed from reopened to closed

comment:12 Changed 7 years ago by cedric

  • Milestone Data integration deleted

Milestone Data integration deleted

Note: See TracTickets for help on using tickets.