James Nobles <james(at)bolshevikhosting(dot)com> writes:
> This is a sample of the file i'm attempting to load, a simple ascii/csv
> cat county.csv|more
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
In response to
pgsql-novice by date
|Next:||From: Greg Sabino Mullane||Date: 2005-07-10 23:01:09|
|Subject: Re: Coding An SQL Statement|
|Previous:||From: Søren Poulsen||Date: 2005-07-10 20:39:33|
|Subject: Table Permission?|