James Nobles <james@bolshevikhosting.com> writes:
> This is a sample of the file i'm attempting to load, a simple ascii/csv
> file.
> cat county.csv|more
> county_code,cntyname
^^^^^^^^^^^
Well, that isn't a valid integer, is it?
In PG 8.1 you'll be able to say "CSV HEADER" to make it ignore the first
line of COPY input, but in existing releases I believe there's no
alternative but to remove the header line.
regards, tom lane