Re: help with COPY from .csv file into database

On Wed, 2004-08-04 at 17:16, michael(at)floog(dot)net wrote:
> Hi Oliver,
>
> This time the copy command appeared to work, except for the "CFW" entry
> in the integer-formatted column, but then trying to view the data shows
> the long hyphenated line again and no readable data.
>
> What do you think is causing this?

Precisely that. Either all the data goes in or none of it does.

Clean up your input file and it will work.

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"And not only so, but we glory in tribulations also;
knowing that tribulation worketh patience; And
patience, experience; and experience, hope."
Romans 5:3,4