| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peralta Miguel-MPERALT1 <Miguel(dot)Peralta(at)motorola(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Bad Date field |
| Date: | 2001-11-29 18:32:51 |
| Message-ID: | 19591.1007058771@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Peralta Miguel-MPERALT1 <Miguel(dot)Peralta(at)motorola(dot)com> writes:
> COPY release_data FROM '/home/mperalta/release_data' USING DELIMITERS '|'
> When I issue this command, the response afte a while is the following:
> ERROR; Bad date external representation '9'
> The external file is rather large and I've tried finding this bad date
> manually with no success.
How old is your Postgres? The last several releases include line
numbers when complaining about COPY problems.
In the meantime, I like the other person's suggestion about importing
into a temp table and then working with the temp table to clean up
the data.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-11-29 18:39:41 | Re: Vaccum |
| Previous Message | bangh | 2001-11-29 18:32:04 | Re: table test |