Re: csv import error

Why don't you use "COPY" ?
Cheers,
Rémi-C

2014-09-23 12:50 GMT+02:00 FarjadFarid(ChkNet) <
farjad(dot)farid(at)checknetworks(dot)com>:

> Hi,
>
>
>
> Quotation marks should be around both the name of each and every column
> and their values.
>
>
>
> Also replace column comas as separation character for sql insert
> statement.
>
> What has happened here is that the values from CSV are directly into sql.
>
> Hope this helps.
>
>
>
> Best Regards
>
>
>
>
>
> Farjad Farid
>
>
>
> *From:* pgsql-general-owner(at)postgresql(dot)org [mailto:
> pgsql-general-owner(at)postgresql(dot)org] *On Behalf Of *Eugenio Trumpy
> *Sent:* 23 September 2014 11:26
> *To:* pgsql-general(at)postgresql(dot)org
> *Subject:* [GENERAL] csv import error
>
>
>
> Hello,
>
> I'm trying to import data using a csv file,
> but I got an error:
>
>
> ERROR: column "key;daprof;aprof;tipo;valore;note;oid;unit_mis" of relation "assorb" does not exist
>
> LINE 1: INSERT INTO "info_pozzi_hydrocarbon"."assorb" ("key;daprof;a...
>
> ^
>
> *In statement:*
>
> INSERT INTO "info_pozzi_hydrocarbon"."assorb"
> ("key;daprof;aprof;tipo;valore;note;oid;unit_mis") VALUES
> ('1001334;19.1;21;A;6;;;11')
>
>
> My sql statement for the table that I would like to populate is:
>
> -- Table: info_pozzi_hydrocarbon.assorb
>
> -- DROP TABLE info_pozzi_hydrocarbon.assorb;
>
> CREATE TABLE info_pozzi_hydrocarbon.assorb
> (
> key integer,
> daprof double precision,
> aprof double precision,
> tipo character(1),
> valore double precision,
> note character(254),
> oid serial NOT NULL,
> unit_mis smallint,
> CONSTRAINT assorb_pk PRIMARY KEY (oid),
> CONSTRAINT assorb_fk FOREIGN KEY (key)
> REFERENCES pozzi (key) MATCH SIMPLE
> ON UPDATE CASCADE ON DELETE CASCADE,
> CONSTRAINT unit_m_fk FOREIGN KEY (unit_mis)
> REFERENCES info_cod.unita (unita) MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION
> )
> WITH (
> OIDS=FALSE
> );
>
>
>
> the csv file is like the following (it is only a part):
>
>
> key;daprof;aprof;tipo;valore;note;oid;unit_mis
>
> 1001334;19.1;21;A;6;;;11
>
> 1001334;93.5;94;A;30;;;11
>
> 1001334;94;115;A;20;;;11
>
> 1001334;154.5;255;A;644;;;11
>
> 1001334;273;282;A;4;;;11
>
> 1001334;298;309;A;7;;;11
>
> 1001334;432;1224;P;1850;;;11
>
> 4277001;121;901;A;397;ALLARGAMENTO FORO;;11
>
> 4277001;121;901;A;96;PERFORAZIONE;;11
>
>
> The filed order it is the same and also the decimal separator is set as dot. I set also the delimiter for fields.
> I don't understand what was the problem.
>
> Can somebody help me?
>
> Eugenio
>
>