invalid input syntax for integer - Mailing list pgsql-novice

From James Nobles
Subject invalid input syntax for integer
Date
Msg-id 1121022182.10120.8.camel@ip24-250-136-203.bc.dl.cox.net
Whole thread Raw
Responses Re: invalid input syntax for integer  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
I've just created my first table and I'm trying to load date into it via
the \copy command. Each time i get the invalid input syntax, no matter
what the type for the column is set too. I've tried int,integer and now
numeric.

Column    |         Type          | Modifiers
-------------+-----------------------+-----------
 county_code | integer               |
 cntyname    | character varying(30) |

 \copy fips_codes_county FROM '/var/lib/pgsql/files/county.csv' USING
DELIMITERS ','

This is a sample of the file i'm attempting to load, a simple ascii/csv
file.

 cat county.csv|more
county_code,cntyname
1,ANDERSON
3,ANDREWS
5,ANGELINA
7,ARANSAS
9,ARCHER
11,ARMSTRONG
13,ATASCOSA
15,AUSTIN
17,BAILEY
19,BANDERA
21,BASTROP
23,BAYLOR
25,BEE
27,BELL
29,BEXAR
31,BLANCO

thanks...


pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: relation does not exist!?
Next
From: Søren Poulsen
Date:
Subject: Re: relation does not exist!?