COPY command with blank incoming values

From: Robert Fitzpatrick <robert(at)webtent(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: COPY command with blank incoming values
Date: 2004-07-02 00:31:18
Message-ID: 1088728278.2831.15.camel@columbus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does COPY require values for each column even though the database field
is not set to NOT NULL? I did a COPY TO first to line up the data and
then COPY FROM a tab delimited file. Here are the first 5 fields in the
first line of the incoming file (omit the quotes, I put them there to
see where the start and end of the line is), you should find 3 tabs
after the second '1':

'1 1 '

I have a table with this structure below and when trying to COPY the tab
separated file into the table, it says it expects and Integer for the
field that does not require a value:

CREATE TABLE "public"."tblxrf" (
"xrf_id" SERIAL,
"seq_no" SMALLINT NOT NULL,
"xlno" SMALLINT,
"site" INTEGER,
"insp" DOUBLE PRECISION,
"flr" VARCHAR(10),
"side" VARCHAR(25),
"room" VARCHAR(25),
"source" VARCHAR(50),
"sub" VARCHAR(50),
"feat" VARCHAR(50),
"cnd" VARCHAR(25),
"clr" VARCHAR(25),
"note" VARCHAR(255),
"ssec" DOUBLE PRECISION,
"date/time" TIMESTAMP WITHOUT TIME ZONE,
"cycle" VARCHAR(25),
"di" DOUBLE PRECISION,
"result" CHAR(3),
"pbl" NUMERIC(3,2),
"pbl_error" NUMERIC(3,2),
"pbk " NUMERIC(3,2),
"pbk_error" NUMERIC(3,2),
"pbc " NUMERIC(3,2),
"pbc_error" NUMERIC(3,2),
"res " VARCHAR(25),
"res_error" VARCHAR(25),
CONSTRAINT "tblxrf_pkey" PRIMARY KEY("xrf_id")
) WITH OIDS;

ohc=# copy tblxrf from '/home/admin/xrf-all.tab';
ERROR: invalid input syntax for integer: ""
CONTEXT: COPY tblxrf, line 1, column xlno: ""

--
Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2004-07-02 02:15:09 Re: postgresql web site gone missing!!!
Previous Message Dennis Gearon 2004-07-02 00:29:25 Re: permissions