| From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
|---|---|
| To: | novice <user(dot)postgresql(at)gmail(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: copy command - date |
| Date: | 2007-08-13 01:59:33 |
| Message-ID: | DF7059B0-788B-4A1C-9592-268A6DF5DB87@seespotcode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Aug 12, 2007, at 20:49 , novice wrote:
> I'm using pg version 8.2.4. What is the best method to load this
> data?
> I have just a little over 55,000 entries.
>
> db5=> \copy maintenance FROM test.txt
> ERROR: invalid input syntax for integer: "3665 OK SM
> 07/07/13 06:09"
> CONTEXT: COPY maintenance, line 1, column maintenance_id: "3665 OK
> SM 07/07/13 06:09"
I'd say your tabs have been converted to spaces so the COPY command
is not delimiting the fields as you expect.
Michael Glaesemann
grzm seespotcode net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Lambert | 2007-08-13 02:18:17 | Re: copy command - date |
| Previous Message | Paul Lambert | 2007-08-13 01:55:15 | Re: copy command - date |