| 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: | Whole Thread | Raw Message | 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 |