From: | "Karen Smallwood" <Karen(dot)Smallwood(at)mightyautoparts(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | COPY with null |
Date: | 2003-11-05 20:27:19 |
Message-ID: | D15742B46C848A49A3C085D96EA5EC91DC37E5@firebird.mightyautoparts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I have seen this question asked, but the answer doesn't seem to have worked for the other person or myself. I have several files I need to copy into postgres and if I try
COPY compmstr from '/user/local/testfile' using delimiters '\t' with null as '' (or '\N' or '\t\t' or anything else);
I get ERROR: copy: line 1, Bad numeric input format '' (or whatever I used). I am using files that can have numeric nulls and/or character nulls
Anyone figure this one out? I'm on 7.3.2
Karen Smallwood
Programmer/Analyst
Mighty Distributing System of America, Inc.
650 Engineering Drive
Norcross, Georgia 30092
(770) 448-3900
(770) 446-8627 fax
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-11-05 20:49:30 | Re: DISTINCT ... ORDER BY |
Previous Message | Nabil Sayegh | 2003-11-05 20:06:30 | Re: DISTINCT ... ORDER BY |