code insert

gistfile1.txt

DROP TABLE instante CASCADE;
CREATE TABLE instante
        ( numar varchar,
    numar_vechi varchar,
    data varchar,
    institutie varchar,
    departament varchar,
    categorie_caz varchar,
    studiu_procesual varchar,
    obiect varchar,
    data_modificare varchar,
    nume varchar,
    calitate_parte varchar,
    solutie varchar
        ); 

COPY instante (numar,numar_vechi,data
     , institutie,departament,categorie_caz,studiu_procesual 
     , obiect,data_modificare,nume,calitate_parte
     , solutie )
FROM '/data/files/florinb/instanta/240_instante_unite_linux.csv'
        WITH CSV HEADER delimiter ','
        ;