csv import error

From: Eugenio Trumpy <frippe12573(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: csv import error
Date: 2014-09-23 10:26:13
Message-ID: DUB123-W86EB5649728CE55066049E5B00@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message FarjadFarid(ChkNet) 2014-09-23 10:50:16 Re: csv import error
Previous Message Craig Ringer 2014-09-23 08:36:39 Where art thou, plpython2.dll? (EDB installer)