Re: help with COPY from .csv file into database - Mailing list pgsql-novice

On Wed, 2004-08-04 at 17:16, michael@floog.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@lfix.co.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